sum-product-if equivalent?

[Mitchell Warden]

I need a way to sum the product of two columns, based on the value of a
third column.
i.e. If A1 = 'ABC' then do B1*C1
.....if A2 = 'ABC' then do B2*C2
and add the lot together.
if only there was a "sumproductif" function.

 

[Jerry W. Lewis]

=SUMPRODUCT((A1:A10="ABC")*1,B1:B10,C1:C10)

should do it. Since you only have a single criteria, you have to
multiply by 1 to convert it from TRUE:FALSE to 1:0.

Jerry