Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumif with multiple criteria
I have a huge spreadsheet (sample below) and I need to know the value of what
2 people have sold. The problem is that the men are listed along the columns and the females are in the rows. I'm sure it's simple - I'm just mental blocking. The sort of results I'd expect a Debbie and Guy have sold $12,100/George and Rebecca have sold $3,000. A B C D E 1 Bob John Guy George 2 Jane $100 $600 $23,000 $2,000 3 Rebecca $200 $5,000 $43,000 $3,000 4 Alison $300 $8,000 $53,000 $400 5 Clair $400 $2,000 $70,000 $5,450 6 Debbie $800 $1,000 $12,100 $8,000 Thanks -- Pebbles |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMPRODUCT / SUMIF on Multiple Worksheets with Multiple Criteria | Excel Discussion (Misc queries) | |||
Multiple Criteria for SUMIF | Excel Worksheet Functions | |||
SUMIF and {multiple criteria} | Excel Discussion (Misc queries) | |||
SUMIF with multiple criteria | Excel Discussion (Misc queries) | |||
sumif multiple criteria | Excel Worksheet Functions |