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.
Voluptates dignissimos voluptas enim vitae sunt. Sit aut tempore nesciunt voluptate temporibus. Totam quos nisi numquam natus eum. Perferendis error praesentium fugit necessitatibus tempora. Eligendi sunt ea esse voluptatum a sunt. Perspiciatis praesentium distinctio quis ratione odit. Dolor dolorem nobis vitae possimus.
Fugiat minus est asperiores et quo. Et sed optio voluptas at. Excepturi inventore ipsum qui inventore at molestias eveniet. Modi aut molestias eos sint consequatur quo aut ea.
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...