Satifying 2 criteria...then sumif

K

kieffer

How can I use the sumif function to do the following. I want to add the
3rd column if the 1st column = D and the 2nd colum = 1?


D 1 30
Q 1 40
R 2 50
R 2 60
Q 1 20
D 2 30
 
D

Dave Peterson

=sumproduct(--(a1:a10="D"),--(b1:b10=1),(c1:c10))

Adjust the range, but don't use the whole column.

=sumproduct() likes to work with numbers. The -- stuff turns true/falses to 1's
and 0's.
 
Top