Adding entry in one cell to a running total in another cell

[TommyB]

Is it possible to enter a number in cell A1 and have it added to a number
that already exists in cell A5 and the new total replaces the current total
in A5?

 

[Gord Dibben]

Possible but not recommended.

How would you audit for errors?

See JE McGimpsey's site for methods.

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


Gord Dibben MS Excel MVP