[Solved] Conditional sum of the product of two columns

[josephj]

How can I do this?

If column A contains 'ABC', then I want to multiply column B by column C and sum it.

I could create a scratchpad column of B*C and conditionally sum that, but can I do it without the scratchpad?

Something like the following would work with D as the scratchpad column.

Code: Select all

=SUMIF($A$9:$A$55,"ABC",$D$9:$D$55)

Code: Select all

A   B C
ABC 2 3
DEF 4 5
ABC 1 5
XYZ 9 8

yields

(2*3) + (1*5) = 11

[FJCC]

This is what the SUMPRODUCT() function is for

Code: Select all

=SUMPRODUCT(A9:A55 = "ABC"; B9:B55; C9:C55)