Sumif question

[Guest]

Hi,
i need a hand with a sumif function.
i am trying to sum where ever i see the word "Super" in column E and then
sum the $dollar values in the column c of the same rows.
Is this possible? i am having some problems with the formula.
The sheet looks like:
Col A Col B Col C Col D Col E
name 2name $val 2nd $val Super
name 2name $val 2nd $val Non Super
name 2name $val 2nd $val Super
Thanks
George

 

[carlo]

Hi george

=SUMIF(E1:E200,"super",C1:C200)

should work fine.
Adjust the numbers according to your workbook.
Or put in whole columns:
=SUMIF(E:E,"super",C:C)

hth

Carlo