I don't know what you have in cell M26 but do you want something like this?

=SUM(J1:J26)-SUM(R11,R13,R15,R17,R19,R21,R23)

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"oxicottin" wrote in message
...
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!!!!