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.

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" <hirsch@discussions.microsoft.com> wrote in message
news:872058B6-41F4-4EFD-84DD-CD66DEEF407C@microsoft.com...
> 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.

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" <hirsch@discussions.microsoft.com> wrote in message
news:872058B6-41F4-4EFD-84DD-CD66DEEF407C@microsoft.com...
>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.