 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / October 2006SUM
Everytime I type in the sum formula, it is exactly right, according to the help menu. When I get my answer, It is always zero, I do not have any numbers in my equation that are negative so I do not see how that is possible. I thought maybe I was typing it in wrong, but then I used the autosum and got the same answer. In the cell with the zero, there is a little green triangle in the top left corner and I move my mouse over it and it says "This cell contains a formula and it is not locked to protect it from being changed inadvertantly." When I click help on this error, I only get a blank white box that says nothing. My only option is to lock cell, which does not help at all. Please help me! Thank You! Are you sure that the cells you are trying to add actually have numbers, not text?  SignatureDavid Biddulph > Everytime I type in the sum formula, it is exactly right, according to the > help menu. When I get my answer, It is always zero, I do not have any [quoted text clipped - 10 lines] > that says nothing. My only option is to lock cell, which does not help at > all. Please help me! Thank You! You can test that by using =COUNT(data) instead of =SUM(data). If COUNT returns zero, then nothing is being recognized as a number. Jerry > Are you sure that the cells you are trying to add actually have numbers, not > text? [quoted text clipped - 12 lines] > > that says nothing. My only option is to lock cell, which does not help at > > all. Please help me! Thank You! I tested count, and it is still zero. But they look like numbers to me, and when i format the cells, i make sure that i select numbers. I dont know why. Maybe it has something to do with the fact that I did not type the numbers in myself, instead, I copied and pasted a chart. > You can test that by using =COUNT(data) instead of =SUM(data). If COUNT > returns zero, then nothing is being recognized as a number. [quoted text clipped - 17 lines] > > > that says nothing. My only option is to lock cell, which does not help at > > > all. Please help me! Thank You! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.