CAN I ADD NUMBERS IN ONE CELL
 

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

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

--
Regards
Frank Kabel
Frankfurt, Germany
"jim1022" schrieb im Newsbeitrag
...
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

See:

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

Regards,

Peo Sjoblom

"jim1022" wrote:

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