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
Microsoft Excel

Avatar of undefined
Last Comment
rodynetwork

8/22/2022 - Mon
barry houdini

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
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
barry houdini

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
rodynetwork

ASKER
You guys are complete geeks. Thanks for the help!
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes