What about when/if the cash flow becomes 0? Is that considered positive?

-10 -5 -4 0 2 4

Try this. Entered as an array using the key combination of CTRL,SHIFT,ENTER
(not just ENTER):

=IF(B10,0,SUM(B1:INDEX(B1:G1,MATCH(TRUE,B1:G1=0, 0)-1)))

Biff

"nkhelp" wrote in message
...
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?