Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple Criteria Sum
I have data like the table below. I need to sum the numbers in column C based
on criteria in columns A and B. Something like a multiple criteria SUMIF A B C 1 a red 1 2 a red 2 3 a white 2 4 b blue 2 5 c red 2 I need to have a formula that allows the criteria to be changed for each cell in a sheet like below that sums the values in the array above based on the values in Row 1 and Column A. A B C 1 Red Blue 2 a A2,B1 A2,B2 3 b A3,B1 A3,B2 4 c A4,B1 A4,B2 Thanks in advance RDW |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count multiple cells against multiple criteria in an Excel spreads | Excel Worksheet Functions | |||
match multiple criteria ina range from multiple criteria multiplet | Excel Worksheet Functions | |||
Index & Match functions - multiple criteria and multiple results | Excel Worksheet Functions | |||
Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions | |||
Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions |