CAN I ADD NUMBERS IN ONE CELL

[jim1022]

hi
i am trying to add up numbers in one extended cell,can this be done if so is
there a formula.
i cannot asign 1 cell per entry as this would make the spreadsheet too long
as it needs printing out afterwards
can anybody help???

jim

 

[Frank Kabel]

Hi
only possible with VBA (see:
http://www.mcgimpsey.com/excel/accumulator.html)

But in general this is not a good idea:
- you'll loose your audit trail
- how do you want to correct wrong entries

Better to enter all data and then create a summary report for example

 

[Peo Sjoblom]

See:

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

Regards,

Peo Sjoblom