Running total within a cell
 

Is it possible to have a cell set up so that when a number is inserted it is
added to the existing number in that cell without having to add them
manually?

Running total within a cell
 

bob2525, You will have no history of what was put in the cells that way, but
if you want to do this have a look here for a way,

http://www.mcgimpsey.com/excel/accumulator.html
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"bob2525" wrote in message
...
Is it possible to have a cell set up so that when a number is inserted it
is
added to the existing number in that cell without having to add them
manually?

Running total within a cell
 

Thank you Paul. This will be a large spreadsheet and we are just keeping
running totals of activities by month. I will look through these solutions
for the easiest one that could be replicated throughout the spreadsheet.
Thanks again.

"Paul B" wrote:

bob2525, You will have no history of what was put in the cells that way, but
if you want to do this have a look here for a way,

http://www.mcgimpsey.com/excel/accumulator.html
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"bob2525" wrote in message
...
Is it possible to have a cell set up so that when a number is inserted it
is
added to the existing number in that cell without having to add them
manually?

Running total within a cell
 

I would not recommend it due to the fact you have no "paper trail" to follow in
case of trouble-shooting data entry.


Gord Dibben MS Excel MVP

On Wed, 4 Oct 2006 08:48:01 -0700, bob2525
wrote:

Thank you Paul. This will be a large spreadsheet and we are just keeping
running totals of activities by month. I will look through these solutions
for the easiest one that could be replicated throughout the spreadsheet.
Thanks again.

"Paul B" wrote:

bob2525, You will have no history of what was put in the cells that way, but
if you want to do this have a look here for a way,

http://www.mcgimpsey.com/excel/accumulator.html
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"bob2525" wrote in message
...
Is it possible to have a cell set up so that when a number is inserted it
is
added to the existing number in that cell without having to add them
manually?