=SUMIF($B$1:$B$6,A13,$C$1:$C$6)

where A13 =IMPULSE or A13=DIRECT works OK for me.

"Beagle" wrote:

Here's the data:

A B C
TOTAL IMPULSE 100.00
TOTAL IMPULSE 100.00
TOTAL IMPULSE 100.00
TOTAL DIRECT 200.00
TOTAL DIRECT 200.00
TOTAL DIRECT 200.00

I need to sum C for either TOTAL, or IMPULSE, or DIRECT

Started using a sumif where =sumif(A2:C6,A13,C2:C6) and A13 = can either be
TOTAL, IMPULE, DIRECT.

When A13 = TOTAL the sumif works (total=900). When A13 = IMPULSE or DIRECT
the sumif does not work.

Please help