In this Excel tutorial, you will learn the cause and solution for the count value not showing in the status bar.
The status bar provides a glance at the real-time information. The count is one of the values that the status bar usually displays. It displays how many cells contain any form of data in a selection.
However, there are instances where users may encounter issues with the status bar not showing the count as expected. It can also cause users to overlook hidden data and real-time monitoring.
The reasons for the count values not properly showing can be from specific settings, such as the display preferences of the status bar, or more complicated issues involving data filtering, hidden rows, etc.
What to Do When Count Is Not Showing in Excel Status Bar?
The count value might be absent for various reasons. The main reason for its absence is the status bar options.
The following figure shows a dataset of the profits of different products in different months. We selected the range of profit. The status bar shows average and sum values. Yet, the count of these cells (5) is absent.
Solution: Change Status Bar Option to Display Count Value
To change the status bar option to display count values, follow these steps:
- Right-click on the status bar at the bottom of the worksheet interface.
- Then select Count from the context menu.
The status bar will now show the total count of the selected cells.
Why Is Status Bar Not Showing Proper Count Values in Excel?
There could be several reasons why the status bar in Excel is not showing proper count values. Here are some common issues and solutions:
1. Proper Range isn’t Selected
The count in the status bar is based on the selected cells. Make sure you have a range of cells selected with the data you want to count.
2. Hidden Rows/Columns
Hiding rows/columns allows users to temporarily conceal specific rows of data. This feature is valuable for focusing on relevant information. However, when a row or column is hidden within a range, Excel ignores them while showing summary values such as sum, average, and count.
Unhide the hidden columns if you want to see the proper values of count as well as sum, average, etc.
3. Filtered Data
Similar to hidden rows, the Filter feature in Excel also hides certain data from a range. When you select filtered data, the count using a function and a feature from the status bar acts differently.
Removing the filters, or selecting all data in the filters results in displaying proper count values in the status bar.
Download Practice Workbook
The absence of critical information such as count values in the status bar of Excel can hinder users’ workflow and maintain efficiency and accuracy. The main cause for the feature not working is the status bar option. There are some other issues like hidden rows and filters which can mess up the count calculation of the status bar.
If you have any questions or suggestions, let us know in the comments below.
Frequently Asked Questions
Why isn’t Excel showing sum in status bar?
There are mainly two reasons for the Excel status bar not showing sum:
- The option is disabled in the status bar context menu.
- Selection is not in proper numeric type (e.g. text) to calculate the sum.
How do I display the status bar?
By default, Excel always displays the status bar. In case you don’t have that in your application, turn the Application.StatusBar property True using VBA to display the status bar. You can use other options to hide and unhide the status bar in Excel.
Does the count in the status bar consider cells with errors?
Yes, the count in the status bar counts every error in Excel. The status bar feature takes account of every non-blank value. This includes the errors.