Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) | |||
Counting multiple numbers in one cell | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions | |||
combining several individual cells of numbers into one cell | Excel Worksheet Functions | |||
How do you extract numbers from a string of chacters in a cell (E. | Excel Worksheet Functions |