Sumif question
 

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

Sumif question
 

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

On Nov 19, 1:58 pm, George wrote:
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