Extracting information from a range of cells.

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?

Hi

I am struggling to understand exactly what you are doing, but the following formula will sum values less than 0:

=SUMIF(A2:G2,"<0")

so you could add this onto your previous balance for example to generate a running total.

Hope this helps!

Richard

that should do it! Im gonna try now and let you know! thank you so much!

That worked!!! I had to make it a little more complicated with nested if statements but I got it... now....
If I wanted to highlight an entire row a certain color... say for example I have a sale, i would do a check for any number in that row which is less than 0... and it will highlight those cells with conditional formatting, but can I make it color the entire row red instead of just those cells?

Josh

Thanks again guys for the other answer