Guide to Why Excel Status Bar Not Showing Count

Solution: Change the Status Bar Option to Display the Count Value

  1. Right-click on the status bar at the bottom of the worksheet interface.
  2. 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 the 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 conceal specific rows of data temporarily. This feature is valuable for focusing on relevant information. When a row or column is hidden within a range, Excel ignores it 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 and sum, average, etc.

3. Filtered Data

The Filter feature in Excel also hides specific 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

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 Excel Parts | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
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