Adding in Excel

[Corey]

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?

 

[Bernard Liengme]

To add the values in A1:A10 use =SUM(A1:A10)

To add the numbers in a block A15, use =SUM(A15)

best wishes

 

[Duke Carey]

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]

I think you're right, I was trying to minimize the amount of lines used. I'm
just splitting them up. Thanks.