Others

How to Fix Excel Count Not Showing on the Status Bar

Maira Mehtab Sep 28, 2026 869 views

Question details

The user has enabled the Count option on the Excel status bar, but the count value is failing to display across all workbooks.

Product: Microsoft Excel
Device & OS: not provided
Scenario: Attempting to view a quick tally of selected cells using the bottom status bar in a spreadsheet.
Observed behavior: The count statistic does not appear on the status bar despite the feature previously working and currently being selected in the customize menu.

Before you start

Ensure that your worksheet contains actual data and that the status bar is visible at the bottom of your Excel application window.

Solution 1Recommended

Select Multiple Nonblank Cells

Excel's status bar is designed to only display the Count metric when you select a range containing at least two cells with data.

A common misunderstanding with the Excel status bar is expecting it to display a count of '1' for a single cell, or to count completely empty cells. By default, the Count function on the status bar evaluates only populated cells and requires a minimum of two nonblank cells in your active selection to trigger the display.

Select a range of cells

Click and drag your mouse to highlight a group of cells in your workbook.

Include populated cells

Ensure that at least two of the cells you have highlighted contain data, such as text, numbers, or formulas. Blank cells will not trigger the count.

Verify the status bar

Look at the bottom right corner of the Excel window to confirm that the 'Count:' metric now appears with the correct number of populated cells.

Blank Cells are Ignored: If you highlight a massive range of completely empty cells, the status bar will remain blank. It strictly counts cells containing data.

Solution 2

Refresh the Status Bar Settings

If selecting multiple nonblank cells does not work, toggling the Count option off and on can resolve temporary interface glitches.

WPS Spreadsheet

Easily View Cell Counts and Statistics with WPS Office

If you frequently encounter interface issues or confusing behaviors in Microsoft Excel, consider trying WPS Spreadsheet. It provides a highly compatible, user-friendly interface with an intuitive status bar that instantly displays counts, sums, and averages for your selected data without the hassle.

1. Open your workbook: Launch WPS Spreadsheet and open your existing Excel file.
2. Enable status bar metrics: Right-click the bottom status bar and ensure 'Count' or other needed metrics are checked.
3. Select your data: Highlight a range of cells to instantly view the real-time count, sum, or average at the bottom of your screen.

Automatically calculates and displays cell counts instantlyFully compatible with Microsoft Excel (.xlsx, .xls) file formatsCustomizable status bar with easy one-click togglesFree, lightweight, and fast alternative to Microsoft Office

microsoft office alternative - wps office

Frequently Asked Questions

Why does my Excel status bar show Sum but not Count?

If the selected range contains numerical data and you only see the Sum metric, the Count option might be disabled in your status bar settings. Right-click the status bar and click on 'Count' to ensure it has a checkmark next to it.

Does the Excel status bar count completely blank cells?

No, the default Count feature on the status bar only tallies cells that contain data, including text, numbers, or formulas. Blank cells are completely ignored in this quick tally.

How do I count blank cells in Excel if the status bar won't do it?

To count blank cells, you must use a formula. Select an empty cell, type '=COUNTBLANK(range)' (replacing 'range' with your actual cell range, like A1:A10), and press Enter.

Can I see a word count on the Excel status bar?

Excel does not have a native word count feature on the status bar like Microsoft Word does. The Excel status bar only counts the number of nonblank cells selected, not the specific words inside them.

Office Quick Solutions