PDA

View Full Version : SUM range with condition

nstaward
10-02-03, 08:43
Hi

Wondering if anyone can help me with a formula, I have a column (G) with a list of values that can be positive, negative or 0. I have two other cells, I want one to show the total of all the cells in G which are positive and the other to show the sum of those which are negative. Is this possible to convey in a single formula

Any ideas gratefully received

Thanks
nstaward
10-02-03, 08:47
have answerd myself, thanks

SUMIF of course...
RickKnight
10-02-03, 11:47
Originally posted by nstaward
Hi

Wondering if anyone can help me with a formula, I have a column (G) with a list of values that can be positive, negative or 0. I have two other cells, I want one to show the total of all the cells in G which are positive and the other to show the sum of those which are negative. Is this possible to convey in a single formula

Any ideas gratefully received

Thanks

See my post response in this forum Subject: Grouping Category