Excel
 

Is it possible to have a cell keep accumulating value from a value entered in
one cell. For instance if cell A2 has 10 and I enter 10 in A1, I would like
cell A2 to increase to 20.

Excel
 

JE McGimpsey shares how:
http://www.mcgimpsey.com/excel/accumulator.html

tfrazier wrote:

Is it possible to have a cell keep accumulating value from a value entered in
one cell. For instance if cell A2 has 10 and I enter 10 in A1, I would like
cell A2 to increase to 20.

--

Dave Peterson

Excel
 

Setting up an accumulator in this way is not advisable:
- How do you correct it if there was an erroneous entry in A1?
- You would have no history from which to verify a particular value in A2.

If you are determined to proceed anyway, there are two possible approaches:
- create a circular reference with calculation options set to a maximum of
1 iteration
- write a macro tied to the worksheet change event to do the accumulation

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

Jerry

"tfrazier" wrote:

Is it possible to have a cell keep accumulating value from a value entered in
one cell. For instance if cell A2 has 10 and I enter 10 in A1, I would like
cell A2 to increase to 20.

Excel
 

Yes, with the A2 formula =A1+A2, but you'll have to look at the warnings
about circular references & adjust the options for iterations. In general,
circular references like this aren't recommended.
--
David Biddulph

"tfrazier" wrote in message
...
Is it possible to have a cell keep accumulating value from a value entered
in
one cell. For instance if cell A2 has 10 and I enter 10 in A1, I would
like
cell A2 to increase to 20.

Excel
 

Thanks for the information. How would you suggest that I keep track of what
was entered. I would like to create a form for Supervisors to enter the
number of inspections made by an inspector and have one column keep a running
total. Is there a way I can keep track of what was entered and still show
the accumulating total.

"Jerry W. Lewis" wrote:

Setting up an accumulator in this way is not advisable:
- How do you correct it if there was an erroneous entry in A1?
- You would have no history from which to verify a particular value in A2.

If you are determined to proceed anyway, there are two possible approaches:
- create a circular reference with calculation options set to a maximum of
1 iteration
- write a macro tied to the worksheet change event to do the accumulation

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

Jerry

"tfrazier" wrote:

Is it possible to have a cell keep accumulating value from a value entered in
one cell. For instance if cell A2 has 10 and I enter 10 in A1, I would like
cell A2 to increase to 20.