Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUMIF with multiple criteria
I'm new to excel...but I know SUMIF checks an array for a particular
value and adds up the cells in a corresponding array for matches. Say I have three columns A=Salesperson, B=Item Sold, C=Amount. I want to sum up the total amount that salesman i sold of item j. I know how to find the total for all things a particular salesman sold, and i can find the total for all sales of a particular item, but how do i find a total of all sales by a salesman of a particular item? I know there are ways to implement this with filters and tons of other ways, but with the way the data is available to me, some kind of modified sumif strategy would be best |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumif with multiple criteria | Excel Discussion (Misc queries) | |||
Sumif with multiple criteria | Excel Discussion (Misc queries) | |||
SUMIF for Multiple Criteria | Excel Worksheet Functions | |||
SUMIF with multiple criteria | Excel Worksheet Functions | |||
SUMIF, multiple criteria | Excel Discussion (Misc queries) |