Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
return multiple rows of data based on criteria | Excel Worksheet Functions | |||
Count Unique Values with Multiple Criteria | Excel Worksheet Functions | |||
Multiple Criteria for Conditional Formatting | Excel Worksheet Functions | |||
COUNTIF or SUM function (Multiple criteria) HELP!! | Excel Worksheet Functions | |||
Multiple Criteria (add or subtract) | Excel Discussion (Misc queries) |