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
__________________________
|