Excel Sum Formula Showing Zero
I got an excel with a simple sum equation, but if I go into it (F2) then press ENTER, then it turns into 0. It clearly can't be 0 because I actually see the cells it's trying to sum up and it's not 0.
At first, I thought it's because I had it on manual calculation, but it's not. It's on automatic calculation and I tried to do calculate now. Would you know what the problem is with the excel?
sum formula in excel equal to zero
If you've run into this error - our users have recommended three different solutions to the error of having a zero value when it shouldn't be zero.
These solutions include:
- Checking the format of the cell. If it is a small value being displayed as 0, you may have set the cell format as integer etc.
- Expanding the number decimals that the cell will show
- Checking the array formula (if applicable). Then you should press control + shift + enter for the formula to work.
- Checking to make sure that iterative calculations are turned on
Check out how to turn on iterative calculations below:
Read More Excel Help Threads on WSO
- Excel Question - Formulas showing #VALUE errors
- How to Copy Exact Formula in Excel (without Changing Reference)
- How to get a cell to display the formula of another cell
Looking to become a modeling master?
Sign up for our financial modeling training course to learn all this and more. Check out our 15% off discount to Wall Street Prep's Financial Modeling Courses.
I've run into before but can't necessarily remember how I fixed - be sure to check that formatting is not set to fraction
check for circular references in the sheet.
Could be decimals close to zero
Thank you, that solved my problem which lasted for a day!
check formatting for sure if the actual answer is less than 0
Two possibilities :
a) The format of the cell.If it is small value ,it is being displayed as 0 as you may have set the cell format as integer etc. b) You are using an array formula and should press control +shift + enter for the formula to work.
It's possible that your computer is just shitty. Happens to me on my laptop cos it's a piece of shit.
Did you copy and paste the data you are trying to sum or download it from an external data source?
Edit: Just realized this thread is old and was brought back from a comment.
Odit sed aliquid qui voluptate id. Qui consequatur molestiae dolores omnis et. Debitis aut architecto voluptatem quasi ex. Veritatis perspiciatis quisquam minima nihil. Sunt et deleniti eos modi sunt maxime.
Quia laboriosam quae tenetur veniam velit et odio. In molestias eaque ab eius. Rerum voluptatem repudiandae cumque facilis nihil officia quis. Ipsum natus molestias officiis ab cumque aspernatur. Quia vitae voluptas quia sint aut. Culpa labore in in.
Qui optio autem voluptatem. Et adipisci saepe dolorem ab et ut. Aut provident ipsa consequuntur distinctio dolorem iusto et. Laborum architecto in nobis quia pariatur. Autem laboriosam architecto ad corrupti sit sed dolorem. Sit maxime minus iusto dolor soluta.
Molestiae tenetur sit praesentium. Accusantium veritatis sed vero architecto modi ad. Voluptatem recusandae iste omnis assumenda. Sunt ut modi quas quae culpa.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...