Thread: Adding in Excel
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernard Liengme Bernard Liengme is offline
external usenet poster
  
Posts: 4,393
Default 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?


Reply With QuoteReply With Quote