| View previous topic :: View next topic |
| Author |
Message |
iomari
Power User
Joined: 22 Aug 2003
Posts: 58
|
 Posted: Tue Nov 22, 2005 1:37 am Post subject: Sum function returns "0' |
 |
|
I have a formula:
SUM(J2:J27)
that only returns 0.
The value in the cells are all numbers. What am I doing wrong? |
|
| Back to top |
|
 |
David
Super User
Joined: 24 Oct 2003
Posts: 5668
Location: Canada
|
| Posted: Tue Nov 22, 2005 6:55 am Post subject: Re: Sum function returns "0' |
|
|
Check your formatting. The formula is likely seeing them as "text", not "number". Select the cells and reformat as number.
David. |
|
| Back to top |
|
|
|
