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.

?????????

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

"duethckey" wrote:

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.

?????????

=A1-A2

"Mike" wrote:

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

"duethckey" wrote:

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


"Mike" wrote:

=A1-A2

"Mike" wrote:

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

"duethckey" wrote:

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.

?????????

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

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"duethckey" wrote in message
...
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


"Mike" wrote:

=A1-A2

"Mike" wrote:

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

"duethckey" wrote:

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.

?????????

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" wrote:

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

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"duethckey" wrote in message
...
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


"Mike" wrote:

=A1-A2

"Mike" wrote:

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

"duethckey" wrote:

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.

?????????