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