

Excel has a very handy feature: It displays some quick information about the selected cells in the status bar. This might be the sum, average, maximum or minimum value. Unfortunately, in some cases, the shown number seems to be wrong. Here is why!
Contents
Customize the information shown in the status bar.
No doubt, the status bar is very helpful. Since the Excel version 2003, you can display more than one type of information. For example, the sum, the average, maximum and so on at the same time.
Customizing the information in the status bar is very easy. Follow these steps:
Example: The sum of cells C3, C4 and C5 should be 6.
Let’s take a look at an example. You have a simple Excel table with 3 rows. When summing up the values of item 1, item 2 and item 3 the result should be 6. This is shown in the screenshot on the right-hand side.
Sometimes, Excel doesn’t show the correct result. There are 3 possible reasons.
The sum (4) seems to be correct.
First of all: you are right. You didn’t make a mistake. But Excel isn’t wrong either. Well, it handles the status bar information in a strange and rather inconsequential way.
When summing up rows, hidden rows in-between are disregarded (see the upper screenshot on the right-hand side).
The status bar regards hidden and grouped columns.
On the other hand, when summing up columns, the shown result regards hidden and grouped columns. This is shown in the lower of the 2 screenshots on the right-hand side.
So how to disregard hidden and grouped columns? Select only visible cells. Follow these steps:
Now, the correct result of all visible cells should be shown.
Hold on a second. Was this information helpful so far?
Why don't you subscribe to our monthly, free Excel newsletter?
Subscribe now! Your welcome gift: Our big 45 pages keyboard shortcuts package. In case the sign-up form above doesn't work, please use this page. Sorry for the inconvenience.
Of course, I'm also on other networks:
Twitter: Follow @professorexcel
Facebook:
Another reason for a wrong result might be that some numbers are formatted as text.
It’s also possible that some cells aren’t formatted as numbers but rather as text. In such case the information in the status bar will show wrong results as well.
Please take a look at the image on the right-hand side. The sum of the 3 cells C3, C4 and C5 should be 6. Instead, Excel shows 4. The reason is that cell C4 is formatted as text instead of a number.
How to handle this? Force all numbers to text. In this simple example it’s easy: Format the cell C4 as number, enter it one time and press Enter on the keyboard.
If you have many cells, please refer to this article for more information of how to force cells to the number format.
Solve or avoid errors.
When you select the range of cells, does Excel show a sum? Or just “Count” and “Numerical Count”? In such case, please check if there are error messages in any of your cells.
So what to do now? You have got several options:
'Professor Excel Tools': Add more than 60 amazing features to Excel!
Professor's Error Helper for Excel: Solve any error in Excel.
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
Comments 3
panuffel
Hi Hendrik, thanks for the post. I stumbled over a fourth option: I had my cells display only one decimal place. The sum in the status bar uses the complete numbers and thus for some cases let to different results.
Tony
Hi!
I have this issue where there is a difference of around 1000 between the sum in status bar and a formula. All cells are formatted the same way, numeric and there are no hidden rows. Also if i copy the values and paste them in another sheet, the status bar gives correct result but nothing helps for the sheet where i need it. Any idea what might be the issue?
Richard
The Excel status bar will not give results for only one item in a column. For 2 or more items it works fine.