[Fixed!] Excel Status Bar Not Showing Count (with Quick Solution)

If your Excel status bar not showing Count, and you are looking for a solution then you have come to the right place. In this article, we will demonstrate to you one easy and quick solution to solve the problem. After reading this article, you will be able to solve the problem effortlessly.

Download Practice Workbook

You can download the Excel file from the following link.


Solution for Excel Status Bar Not Showing Count

The following dataset has the Month, Product, and Profit columns. Using this data table, we will demonstrate to you the solution for the Excel Status bar not showing Count. In this article, we used Microsoft Office 365. You can use any available Excel version.

Excel Status Bar Not Showing Count

Let us first describe to you how the Status bar works in Excel.

You can see in the following picture that when we select the values of the Profit column, the Average, Sum and Count appears on the bottom side of the Excel sheet. This is the Status bar. By default Excel Status bar shows the Average, Sum, and Count of the selected data.

Reason:

The Status bar will not show Count if the Count is unmarked in the Customize Status Bar.

Here, you can see in the following picture that after selecting the Profit column’s value, the Status bar on the bottom shows Average and Sum. Here, however, Count is not showing.

Now, we will describe the solution to this problem when the Status bar not showing Count.

This is because the Count is unmarked in the Customize Status Bar.

Excel Status Bar Not Showing Count


Solution: Using Customize Status Bar

To solve the problem of the Status bar not showing Count, we will use the Customize Status Bar.

Let us discuss the steps to solve the problem:

  • First of all, select the Profit column’s value to bring out the Status bar.

Next, you can see the Status bar with Average and Sum.

  • After that, right-click on the Status Bar.

At this point, a Customize Status Bar dialog box will appear.

Afterward, you can notice that Count is unmarked in the dialog box.

Excel Status Bar Not Showing Count

  • Furthermore, we will mark the Count.

As a result, you can see the Status bar is showing Count.

Therefore, the problem is solved.

Excel Status Bar Not Showing Count


Excel Status Bar Not Showing Sum and Average

In the following picture, you can see that when we select the values of the Profit column to bring out the Status bar, the Status bar appears. However, the Sum and Average are missing in the Status bar. It is only showing Count.

Reason:

The Status bar will not show Sum and Average when the numeric values are formatted as text by using apostrophes, text format, or other functions.

Here, when we select cell D5 of the Profit column, you can see in the Formula bar that the cell has an apostrophe before the value. This apostrophe is not showing in cell D5 unless we click on the cell. As no Average or Sum is showing in the Status bar, all the cells of the Profit column have apostrophes. As a result, the Status bar not showing Average and Sum.


Solution: Removing Apostrophes from Cells

To solve the problem of the Status bar not showing Sum and Average, we have to remove the apostrophe from the cells of the Profit column. To do so, we will go through the following steps.

  • First of all, we have to select the apostrophe.
  • Afterward, press DELETE.

Excel Status Bar Not Showing Count

As a result, you can see there is no apostrophe in cell D5.

  • Repeat the following procedure for other cells of the Profit column.

Next, we will select the Profit column’s value to bring out the Status bar.

You can see the Status bar now contains Sum and Average along with Count.

Hence, you can solve the problem.


Conclusion

Here, we tried to show you the solution for the Excel status bar not showing count. Thank you for reading this article, we hope this was helpful. If you have any queries or suggestions, please let us know in the comment section below. Please visit our website Exceldemy to explore more.

Afia

Afia

Hello, I am Afia Aziz Kona. I graduated in Naval Architecture and Marine Engineering from Bangladesh University of Engineering and Technology (BUET). I have an immense interest in technical writing and content development, therefore, I am working as a content developer at Exceldemy. In my spare time, I travel, watch movies, and cook different dishes.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo