G
Guest
I need help with the formula to stop adding when the cell number becomes a
positive number. I am looking at different senarios for a breakeven point.
I need one cell to add only numbers that are negative.
EXAMPLE
A B C D E F G
SUM -10 -5 -4 -1 2 4
I need A1 to add only through E1, but the sum addition needs to include
cells F-G because they may change to a negative number when I change another
calculation.
Make Sense?
positive number. I am looking at different senarios for a breakeven point.
I need one cell to add only numbers that are negative.
EXAMPLE
A B C D E F G
SUM -10 -5 -4 -1 2 4
I need A1 to add only through E1, but the sum addition needs to include
cells F-G because they may change to a negative number when I change another
calculation.
Make Sense?