SUM of subtracting and then adding different cell

[Kurt]

I want to be able to make a "seperate cell" that will ony hold a $ amount in
it and then when I put new numbers into two other cells it will give the sum
of thoe two and then add the seperate one...something goofie like this...
=SUM(LMNO18-LMNO19+"SEPERATE CELL")

 

[Kurt]

Hmmmm, I got it...It was =SUM(L18-L19+H5)

 

[Pecoflyer]

I want to be able to make a "seperate cell" that will ony hold a $
amount in
it and then when I put new numbers into two other cells it will give
the sum
of thoe two and then add the seperate one...something goofie like
this...
=SUM(LMNO18-LMNO19+"SEPERATE CELL")

Hi,
you do not need the sum function for this
=cell1-cell2 + separatecell will do.
Of course this formula should not be entered in the cell "separatecell"
but somewhere else


--
Pecoflyer

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows file
upload ->faster and better answers

*Adding your XL version* to your post helps finding solution faster