One possible cause is copying/pasteing/linking to a cell with embedded £, $ etc signs in them. They will still add up using A1+A2 etc but SUM cannot hack
the embedded signs.
The solution is to use the VALUE function which strips out the embedded signs and SUM will now work. This will probably mean duplicate cells to make it work. EG
=VALUE(enter in here the link or cell the problem number is in). Then SUM this column/row.
This doesn't seem to have anything to do with Options or cell formats.
The Menace
"Dennis (The Menace) Hayden" wrote:
I have this problem also. I even tried moving the spreadsheet to different PCs, and opening it in 2007.
In the end I substituted =SUM(A1:A5) for =A1+A2+A3+A4+A5 And low and behold
it works. So there seems to be "SUMthing" wrong with this function under certain conditions.
Den
"Marcie" wrote:
Good Afternoon! I am having a similar problem and have tried all of the suggestions below and nothing worked. I copied some values from my cell phone bill on the net and tried to sum them. The values copied very nicely
into Excel but do not sum. If i retype the numbers over the original number
they will then start to sum which to me suggests formatting. Keep in mind
I've tried all of the below mentioned tricks. Any more thoughts? Thanks! Marcie
"Parry" wrote:
I'm a novice...and self-taught, but I love Excel. Can someone please explain
why when I enter a formula to add a column of numbers, the formula is showing
in the cell and not the sum. the formula is: =sum(e27:e42) Have they changed how a formula is written in Excel 2007? Even after I format the
cells to be numbers versus text, the sum function won't show a sum...just the
formula. Sometimes all I get is a zero. How can I fix this? It's very frustrating. Thx.
--
Novice
Thanks
Sysop: | Keyop |
---|---|
Location: | Huddersfield, West Yorkshire, UK |
Users: | 296 |
Nodes: | 16 (2 / 14) |
Uptime: | 71:07:51 |
Calls: | 6,656 |
Calls today: | 2 |
Files: | 12,201 |
Messages: | 5,332,212 |
Posted today: | 1 |