Spreadsheet question

  • Thread starter Thread starter Dee
  • Start date Start date
D

Dee

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)" ?
 
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.
 
Hi Dee,

Let me put it another way.

We are not here for your rehearsel. We are here to help you (and others).
If there is something you don't understand, explain what you did (give
formulas and values), what you expected to happen and what happened instead.
 
Back
Top