Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding in Excel
I used the alt+enter function to have multiple rows of numbers in one cell.
Now I want to add these rows of numbers separately in another cell without spliting the cell. Is it possible to add multiple numbers in a cell? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding in Excel
To add the values in A1:A10 use =SUM(A1:A10)
To add the numbers in a block A1:D5, use =SUM(A1:D5) best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Corey" wrote in message ... I used the alt+enter function to have multiple rows of numbers in one cell. Now I want to add these rows of numbers separately in another cell without spliting the cell. Is it possible to add multiple numbers in a cell? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding in Excel
Not ABSOLUTELY sure, but I think you're out of luck.
Of course, the question that has to be asked is 'why did you do it that way?' "Corey" wrote: I used the alt+enter function to have multiple rows of numbers in one cell. Now I want to add these rows of numbers separately in another cell without spliting the cell. Is it possible to add multiple numbers in a cell? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding in Excel
I think you're right, I was trying to minimize the amount of lines used. I'm
just splitting them up. Thanks. "Duke Carey" wrote: Not ABSOLUTELY sure, but I think you're out of luck. Of course, the question that has to be asked is 'why did you do it that way?' "Corey" wrote: I used the alt+enter function to have multiple rows of numbers in one cell. Now I want to add these rows of numbers separately in another cell without spliting the cell. Is it possible to add multiple numbers in a cell? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding with excel | Excel Discussion (Misc queries) | |||
Adding in Excel | New Users to Excel | |||
Adding in Excel | Excel Discussion (Misc queries) | |||
Adding Tax in excel | Excel Worksheet Functions | |||
Adding in Excel | Excel Discussion (Misc queries) |