Conditional sum

[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

 

[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

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

Rgds

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________

 

[Guest]

sumif() should work for you

=sumif(B1:B10,"O",A1:A10)

 

[Ray]

It works well.

Many thanks!

Ray

sumif() should work for you

=sumif(B1:B10,"O",A1:A10)