Excel

T

tfrazier

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.
 
J

Jerry W. Lewis

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
 
D

David Biddulph

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.
 
T

tfrazier

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.
 
Top