Check out this link to John McGimpsey's web page on the subject:

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

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"hirsch" wrote in message
...
I want to be able to use a single cell to add and each time I add a new
number it give a new total for example when I first insert 5 in a cell c3
then in the same cell when I insert 13 it automatically shows 18 and when
I
insert 22 it automaticall shows 40 and whenI insert 6 it automatically
shows
46 etc etc.