Excel formula to add then subtract

[Dagonini]

I am trying to add together a group of cells then subtract that total
from another number and put the result into a cell. My formual is:
=SUM(B112)-(B106:B111)

So what I am trying to do is take the total value of cells B106
through B111 and subtract them from the amount in cell B112. This
would then be all in B113. For some reason excel doesn't recoginize
the (b106:b111). what am I doing wrong?

 

[merjet]

=SUM(B112)-SUM(B106:B111) or =B112-SUM(B106:B111)

Hth,
Merjet

 

[Guest]

The formula that you have does not match what you stated you are trying to
do. Try this formula (placing it in B113):

+B112 - SUM(B106:B111)

Les

 

[Dan R.]

=SUM(B112)-SUM(B106:B111)

-- Dan

 

[Gord Dibben]

=B112-SUM(B106:B11)


Gord Dibben MS Excel MVP