Adding within a cell

[Guest]

I'm adding to the same cell continouslythroughout my worksheet. Can I keep entering data within a cell and have it add on its own without having to add in my head and change the cell each time??

 

[JE McGimpsey]

Take a look at

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

 

[Earl Kiosterud]

Rosa,

JE's solution is slick, in that you can type the number into the cell
containing the current total, and it adds your entry to the total. For a
non-macro, it can also be done with a formula, using iteration, though the
total is kept in a separate cell from one in which you supply your values.

A problem with such a setup is that you have no record (other than your
memory) what you've put into it. It just swallows them up. What's normally
done is to list all the values in cells, and provide a sum with a formula in
a cell.
--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

I'm adding to the same cell continouslythroughout my worksheet. Can I

keep entering data within a cell and have it add on its own without having
to add in my head and change the cell each time??