=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!