SumProduct
 

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

SumProduct
 

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


"Sweepea" wrote:

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

SumProduct
 

Thank you so much!!! It works!



"Teethless mama" wrote:

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


"Sweepea" wrote:

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