Adding in Excel

  • Thread starter Thread starter Corey
  • Start date Start date
C

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?
 
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
 
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?'
 
I think you're right, I was trying to minimize the amount of lines used. I'm
just splitting them up. Thanks.
 
Back
Top