Multiple Criteria Sum
Hi JP,
Thanks, it took me a few minutes to figure out I had to enter this as an
array but now I got it. Works good thanks.
RD
"JP Ronse" wrote:
Hi,
Try ...
=SUM(($A$1:$A$5=$A10)*($B$1:$B$5=B$9)*($C$1:$C$5)) in A10:C12
A B C
9 Red Blue
10 a
11 b
12 c
Wkr,
JP
"RD Wirr" wrote in message
...
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
|