Im am sorry I should have said what I had in cell "M26" the formula thats
already in there is =SUM(H9:H23) I just want to be able to enter numbers in
the "R11,R13,R15,R17,R19,R21,R23" Cells and have it subtract from the total
that was in the "M26" Cell.... Is this possible?

Thanks,
Chad



"Sean Timmons" wrote:

it wouldn't. In, say, M27, you can put =M26-sum(R11:R23)

"oxicottin" wrote:

Hello, I was woundering if someone could give me the formula for this? I have
A cell "M26" that has a total number in it from a sum from another cell. And
I have a row of cells "R11,R13,R15,R17,R19,R21,R23" that are blank. What I
want to do is when I enter a number in one of the "R" cells it would subtract
that number from the M26 cell. Will this give an error or something because
the number in the M26 is a total from another formula.

Thanks!!!!