Using Sumif with 2 conditions

C

Cheryl W

I want to sum the data in column c if column a= 915 and column c >=1001. I
can't get it to recognize the 2nd condition (column c>=1001). Please help!
 
D

David Billigmeier

=SUMPRODUCT(--(A1:A10000=915),--(C1:C10000>=1001),C1:C10000)

Change the row numbers to fit your data.
 
A

Alan

=SUMPRODUCT(--(A1:A24=915),--(B1:B24>1001),--(C1:C24))
Note that 915 can be contained in a cell like
=SUMPRODUCT(--(A1:A24=F1),--(B1:B24>1001),--(C1:C24))
Regards,
Alan.
 
C

CarlSprake

Alan,

Thanks very much for providing this solution, it was just the thing I was
looking for as well. However, I can't see how the SUMPRODUCT function is
working in this case. The two minus signs are obviously critical but why?

Can you answer this for me, or point me in the direction of an explanation
please.

Thanks

Carl Sprake
Oxford
 
Top