How sum numbers in the same cell and entry

[JC-PS]

Hi, let's say I entered 3.5 in A1 and then the next day I updated the cell
to an additional entry of hours, but on decimal values.
Can Excel total these two entries in A1 to get a total in the same cell. I
don't
want to use a separate cell to add up each entry. Not enough space.

Your help is greatly appreciated.

Sincerely, John C.

 

[Gord Dibben]

Excel 97 through 2003 have over 17,000,000 cells per worksheet.

Excel 2007 has almost 17,000,000,000 cells per worksheet.

You can't find enough space?

What you want could be done using one or two cells, but you would have no
way to allow for and correct mistakes in input.

See John McGimpsey's site for setting an accumulator cell using code or a
worksheet function.

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


Gord Dibben MS Excel MVP

 

[Héctor Miguel]

hi, John C. !

... let's say I entered 3.5 in A1 and then
the next day I updated the cell to an additional entry of hours, but on decimal values.
Can Excel total these two entries in A1 to get a total in the same cell.
I don't want to use a separate cell to add up each entry. Not enough space...

IMHO the best way to keep cummulative values is using two cells (the value & the accumulator)
if you prefer by code (worksheet events) you need to declare ALL the cells to control its values
and each time the code is executed, you miss the undo (ctrl + Z) stack-level
besides, i guess you would like not to opdate the code once and again, so...

- how many cells do you need to control ?
- and using the two cells approach preserves the enough space ?

regards,
hector.