Sum Help

[Anuviswan]

Hi All

Support I have a table like following.

Col1 Col2
30 X
20
3 X
50 X
2
33
--------------
(Sum Here)

I want to calculate sum at (Sum Here) so that, I get sum of values in Col1 which has X marked in Col 2 ? For example, in above case, i would get, (30+3+50).

Can any one please help ?
Anu

[hudibyk]

Use SUMIF function

[AZ-XL]

=SUMIF(B1:B6,"x",A1:A6)

[Sam Capricci]

you can use =SUMIF(B:B,"x",A:A) roughly what AZ gave you.
Of course you have to put your results in a different location than at the bottom of col A.