So I am using excel 2010, I am trying to use a SUM formula, =SUM(B3:B14). The formula wizard shows the correct answer but when I hit the ok button the cell is blank, the formula is displayed in the formula bar. If I try to copy the same formula from a working cell then right click the cell to paste, it shows the correct answer. But no matter what I do I can not get it to show the answer in the cell. I would pull my hair out if I had any.
Hard to tell without seeing the spreadsheet.
One guess though: Check your font color for the cell. If you have a white background and somehow formatted the text to be white, you won't actually see anything.
Otherwise, I'd recommend you post a sample spreadsheet that reflects the problem you're having.
S
------------------------------------------------------------------------------------------
If you need no more help on the current problem, please mark it as "Solved". It saves time
as many of us will look at threads if they are not marked as "Solved".
The instructions on how to do this are found in the Forum Rules thread that is at top of every forum.
(Currently you'll have to look at point #9.)
------------------------------------------------------------------------------------------
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
kamileon 
Register To Reply
Bookmarks