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 Expand viewCollapse view
`=SUMIF($A$9:$A$55,"ABC",$D$9:$D$55)`

- Code: Select all Expand viewCollapse view
`A B C`

ABC 2 3

DEF 4 5

ABC 1 5

XYZ 9 8

yields

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