Using Sumif with 2 conditions
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
"Alan" wrote:
=SUMPRODUCT(--(A1:A24=915),--(B1:B241001),--(C1:C24))
Note that 915 can be contained in a cell like
=SUMPRODUCT(--(A1:A24=F1),--(B1:B241001),--(C1:C24))
Regards,
Alan.
"Cheryl W" wrote in message
...
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!
|