SumProduct

S

Sweepea

Question:

A B C
123 20/30 $100
123 30/30 $200
456 20/30 $300

I want to sum up total in column C with the following conditions:
if column A =123 AND column B = 20/30 or 30/30

Result should be: $300

When I do a sumproduct with text, it works well ... but it doesn't work with
numbers.

Please help. Thank you
 
T

Teethless mama

=SUMPRODUCT((A1:A100=123)*((B1:B100="20/30")+(B1:B100="30/30"))*C1:C100)
 
Top