Conditional sum
 

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

On Mon, 5 Sep 2005 22:29:58 +0800, "Ray"
wrote:

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
__________________________

sumif() should work for you

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

"Ray" wrote:

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

It works well.

Many thanks!

Ray

"bj" wrote in message
...
sumif() should work for you

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

"Ray" wrote:

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