Link to home
Create AccountLog in
Avatar of rodynetwork
rodynetwork

asked on

Excel sheet calculation problem

See the attached sheet.  When I select column C, the sum is 5.68434E-13. Why?  The sum should be zero.  Normally I can click on C and it will give an accurate sum.  What do I need to address? 51003EE.xls
Avatar of barry houdini
barry houdini
Flag of United Kingdom of Great Britain and Northern Ireland image

Not sure that you can change what it shows on the status bar....that just reflects the value you get if you use the formula = SUM(C:C)

That amount is a number very close to zero, the reason it isn't zero is to do with the way Excel calculates - it can sometimes result in small "precision errors". You can get the correct sum in a cell by rounding e.g.

=ROUND(SUM(C:C),9)

regards, barry
Avatar of rodynetwork
rodynetwork

ASKER

Hi Barry,

Ket me clarify what I am asking. I have for several years now simply clicked on the C column and the sum of that column appears at the bottom of my window.  That always works and it is always accurate. A few days ago something happened where I import a few lines of data and every since then the C column has that weird " 5.68434E-13" instead of the actual number.  Here's another wierd thing: if I delete a row, it will sum correctly. Any row, not just a particular row, but delete any row and the sum works.  Ok, now that I am articulating this, I think I may realize what you are saying....are you saying the weird " 5.68434E-13" is excels way of saying "zero"?
ASKER CERTIFIED SOLUTION
Avatar of barry houdini
barry houdini
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
You guys are complete geeks. Thanks for the help!