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?

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?

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?

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?