Sum

damian_r

Active Member
Joined
May 4, 2004
Messages
389
Hi,

I’m currently trying to get a sum of a column which will only count the number in that column if the cell to the right of that column is a positive number.

The total of the column is in cell F29. This is the total of the numbers in cells F4 to F28 inclusive.
However, as an example, if cell E15 has a negative number in it, I don’t want the value in cell F15 to be part of the sum in cell F29.
All in all, this sum will be in cells F29 to T29, but it should always look back to the cells in column E to look for negative values.

I’ve tried some countif formulas but I think I’m on the wrong track with that idea

Once again, I’d appreciate your help on this one.


Damian
 

Some videos you may like

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

Watch MrExcel Video

Forum statistics

Threads
1,113,947
Messages
5,545,134
Members
410,663
Latest member
iilex
Top