Excel Status Bar Not Showing Count (Quick Fix)

Get FREE Advanced Excel Exercises with Solutions!

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.

count not showing in excel status bar fixed


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.

Excel Status Bar Not Showing Count

Solution: Change Status Bar Option to Display Count Value

To change the status bar option to display count values, follow these steps:

  1. Right-click on the status bar at the bottom of the worksheet interface.
  2. Then select Count from the context menu.
    Excel Status Bar Not Showing Count

The status bar will now show the total count of the selected cells.

Excel Status Bar Not Showing Count


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.

hidden rows interaction with count in the status bar

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.

filter interaction with count in the status bar

Removing the filters, or selecting all data in the filters results in displaying proper count values in the status bar.


Download Practice Workbook


Conclusion

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:

  1. The option is disabled in the status bar context menu.
  2. 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.


Related Article


<< Go Back to Status Bar in ExcelExcel Parts | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Afia Kona
Afia Kona

Afia Aziz Kona, a graduate of Civil Engineering from Khulna University of Engineering & Technology, Bangladesh, serves as a technical content creator in the ExcelDemy project. Possessing a passion for innovation and critical thinking, she actively embraces challenges. Beyond her engineering background, Afia exhibits a keen interest in Excel, having authored numerous articles on Excel & VBA-related issues to simplify the experience for users facing obstacles in Excel. Apart from creating Excel tutorials, she is also... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo