G
Guest
When I use a forumula to sum cells [e.g., "=sum(F84:F96)"] the answer given is zero. Even though the formula is correct and on display in the viewer. What gives?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
T
Trevor Shuttleworth
A guess would be that the data that look like numbers are, in fact, being
seen by Excel as text. Have you entered the data or imported it ?
Regards
Trevor
viewer. What gives?
seen by Excel as text. Have you entered the data or imported it ?
Regards
Trevor
given is zero. Even though the formula is correct and on display in thegjpundsack said:When I use a forumula to sum cells [e.g., "=sum(F84:F96)"] the answer
viewer. What gives?
G
Guest
Thank you for responding. I entered the date and I have verified that each cell is formatted in $ as I wished it to be. Since then, I have found the cells are "locked". What's that?
T
Trevor Shuttleworth
It means that you cannot change the data in the cells ... but it is only
effective if the sheet is protected. Even then it wouldn't affect the
formula. Try selecting each cell and pressing F2 to edit it. Are there any
other characters in the cell besides the numbers ? If so, delete them and
press Enter
Regards
Trevor
the cells are "locked". What's that?
effective if the sheet is protected. Even then it wouldn't affect the
formula. Try selecting each cell and pressing F2 to edit it. Are there any
other characters in the cell besides the numbers ? If so, delete them and
press Enter
Regards
Trevor
each cell is formatted in $ as I wished it to be. Since then, I have foundgjpundsack said:Thank you for responding. I entered the date and I have verified that
the cells are "locked". What's that?