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.
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.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
