Multiple criteria

K

Krish

I have a spreadsheet with Invoice #, Date, SalesRep,Sales Amount and Margin
Amount. I would like to get the Margin Dollars total grouped between >75,
75-150,150-300,>300 and also count the number of Invoices for those groups.
How can I accomplish that?

Thanks
K
 
B

Bob Phillips

=COUNTIF(E:E,"<75")

counts them

=SUMIF(E:E,"<75")

sums the value.

And then

=COUNTIF(E:E,">=75")-COUNTIF(E:E,">=150")

and

=SUMIF(E:E,">=75")-SUMIF(E:E,">=150")

etc.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Top