Conditional sum

R

Ray

I would like to sum a column depending the condition of another column as
below:-

A B
---------
3 O
4 O
2
1 O
5
2 O
----------
Sum up the cells of column A if O exists on the same row of the column B.

Thanks,

Ray
 
R

Richard Buttrey

I would like to sum a column depending the condition of another column as
below:-

A B
---------
3 O
4 O
2
1 O
5
2 O
----------
Sum up the cells of column A if O exists on the same row of the column B.

Thanks,

Ray
Click to expand...

=sumif(B:B,"O",A:A)

Rgds

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________
 
Top