in the one cell add 5+13+22+6+ to get cumulative total each time?
 

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.

in the one cell add 5+13+22+6+ to get cumulative total each time?
 

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.

in the one cell add 5+13+22+6+ to get cumulative total each time?
 

You need a macro for that,

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

look for single cell accumulator

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


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