I can't see your spreadsheet pic, but this should do what you need.

enter this formula in column E (where your total is) and copy down

=IF(B20,B2+E1,IF(B2<-.99,B2+E1,E1))

Hope that helps.

Celt


--
Celt
------------------------------------------------------------------------
Celt's Profile: http://www.excelforum.com/member.php...o&userid=19413
View this thread: http://www.excelforum.com/showthread...hreadid=532524