Multiple criteria
 

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

Multiple criteria
 

=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)

"Krish" wrote in message
. ..
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