Formula for subtracting

[duethckey]

I have one cell with entered numbers (no formula in this cell). This is cell
J5

The other cell is a result of a formula which is =SUM (J5:K5). THis is cell L

I need to create a formual which allows me to add result of cell 7 minus
cell J5 entry.

?????????

 

[Mike]

A1-A2 Put this in cell A3 to test Will Subtract A1 minus A2

 

[Mike]

=A1-A2

A1-A2 Put this in cell A3 to test Will Subtract A1 minus A2

 

[duethckey]

Mike, I am so confused....
Here is what I have on the existing spreadsheet that I am trying to update:

Column A is a manually entered number (17,000 for example)
Column B was previously manually entered as a calculation on my calculator
which was the number in Column A plus the number in Column B
Column C is a formula column which is total of A plus B (=SUMA1:B1)

What I want to do is place a formula in column B to calculate A plus B

so I only manually enter Column A.

Any help is greatly needed and appreciated! Thanks

 

[RagDyer]

<<<"What I want to do is place a formula in column B to calculate A plus
B">>>

Have you re-read this?

In B1 you want to enter a formula to add A1 to B1? ? ?

Do you mean that if A1 contains 10,
And you type 5 into B1, you want B1 to display 15?

This creates a circular reference and can be very troublesome.

Check out this link of JE McGimpsey:

http://www.mcgimpsey.com/excel/accumulator.html

 

[duethckey]

I understand but this is really what this spreadsheet needs to do. I figured
out away to make the circular reference work.
Are you saying the danger is in the data entry error without the history?

 

[RagDyer]

Yes !

How well do you trust your users ... OR yourself?

You've never made a mistake?

 

[iliace]

You really should have the sum in column C.

Or, not sure if this helps in your case, but one method would be
this. Copy column A. Select Column B. Go to Edit/Paste Special.
Select Formulas, and Add. Click OK. Check the resulting formula in
column B, perhaps that works for you?