Excel Sum Formula Showing Zero

l2010's picture
Rank: Senior Orangutan | 470

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

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.

Financial Modeling Training Course

Comments (9)

May 27, 2012

I've run into before but can't necessarily remember how I fixed - be sure to check that formatting is not set to fraction

May 27, 2012

check for circular references in the sheet.

May 27, 2012

Could be decimals close to zero

  • Anonymous Monkey
  •  Jul 8, 2016

Thank you, that solved my problem which lasted for a day!

May 27, 2012

check formatting for sure if the actual answer is less than 0

May 27, 2012

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.

May 27, 2012

It's possible that your computer is just shitty. Happens to me on my laptop cos it's a piece of shit.

Jul 27, 2016

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.

Mar 29, 2018