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)" ?

60. Why ask, though? Can just put it in Excel........

"Dee" wrote:

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.

--
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)" ?

What do *you* think?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"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)" ?

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.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"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)" ?

60


Gord Dibben MS Excel MVP

On Thu, 22 Oct 2009 13:36:04 -0700, Dee
wrote:

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)" ?