The result *should* be 60. If you get a result of 0 then the numbers in the
cells are TEXT. The cells may be formatted as TEXT or there may be unseen
characters in the cells like leading/trailing spaces.

--
Biff
Microsoft Excel MVP


"Dee" wrote in message
...
Considering an Spreadsheet with the following cell values respectively
A1=10,A2=20,A3=30,A4=40. What would be the result of the formula
"=sum(A1:A3)" ?