Heres my problem, I have a set of numbers in each cell that add up to a total at the end of a row. Its an inventory of traveler checks. If we sell any on a day we make the next row with who we sold to, and leave positive numbers in anything we didnt sell, then use a negative to signify how many we sold. I am trying to automate the system, As of right now I have this formula...

=IF((OR(D794<0,E794<0,F794<0,G794<0,H794<0,I794<0,J794<0,K794<0)),2,1)
And what this does is checks that range of cells to see if there is a negative number... true is 2 and false is 1 of course. Now what im wondering is if there is a way to pull out the negative cells and make a formula that subtracts thosae negatives from the previous balance creating a new balance.
Exa.


date #1|#2|#3|#4|#5|#6 Total
7/6/2007 0 | 2 | 3 | 0 | 4 | 5 14
7/7/2007 0 |-1| -2| 0 | 4 | 5 11
Ballance 0 | 1 | 1 | 0 | 4 | 5 11

Any ideas?