Subtract numbers
 

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!!!!

Subtract numbers
 

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!!!!

Subtract numbers
 

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!!!!

Subtract numbers
 

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!!!!

Subtract numbers
 

Hi,

Maybe:

=M26-SUM(IF(MOD(ROW(R11:R23),2)=MOD(ROW(R11),2),R11:R23 ))

the formula must entered using CTRL+SHIFT+ENTER not just ENTER.

Hope this helps!
Jean-Guy

"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!!!!

Subtract numbers
 

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?

If you mean have the subtraction showing in the same cell as the entry in
the R column then no, you cannot have a data entry and a formula in the same
cell.

You can have in another cell the formula:

=M26-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
...
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!!!!

Subtract numbers
 

Sandy Thanks this is what I needed!! And thanks to all that replyed....




"Sandy Mann" wrote:

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!!!!