Office Settings & Configuration

How to Fix Missing Count on Excel Status Bar

Maira Mehtab Sep 20, 2026 869 views

Question details

The user is unable to see the Count metric on the spreadsheet status bar and needs to restore or activate the feature to view summary statistics.

Product: Microsoft Excel
Device & OS: not provided
Scenario: Trying to view quick summary statistics for selected cells at the bottom of the spreadsheet workspace.
Observed behavior: The Count statistic does not appear on the status bar, even when the user expects to see the number of currently selected cells.

Before you start

Ensure you have an active worksheet open with actual data in the cells, as selecting completely empty cells will not trigger the quick count function.

Solution 1Recommended

Enable the Count Option in the Status Bar

Verify that the Count feature is actively checked in the customize status bar menu.

The status bar in Excel is customizable, meaning certain metrics can be turned on or off manually. If Count was accidentally disabled, it will not show up regardless of what you select.

Open Status Bar Menu

Right-click anywhere on the blank space of the Excel status bar located at the very bottom of the application window.

Check Count

Look for 'Count' in the list of available metrics and click it to ensure there is a checkmark next to it.

Status Bar Customized: Once enabled, the Count metric will remain active for all future workbooks unless you manually disable it again.

Solution 2

Select Multiple Cells with Content

Excel requires a selection of at least two non-empty cells to display the Count metric.

Efficient Data Analysis

Easily View Cell Counts and Stats in WPS Spreadsheets

WPS Spreadsheets provides an intuitive status bar that instantly displays real-time statistics like Count, Sum, and Average for your selected data, helping you analyze information effortlessly.

1. Open your Spreadsheet: Launch WPS Office and open your .xlsx or .csv workbook.
2. Select the Data: Highlight two or more cells containing the data you want to count.
3. Check the Status Bar: Look at the bottom right of the WPS window to see the 'Count' automatically displayed.
4. Customize the Status Bar: Right-click the status bar to easily toggle other metrics like Sum, Numerical Count, or Average on and off.

Instantly view Count, Sum, Average, and Max/Min directly on the status barFully compatible with Microsoft Excel (.xlsx and .xls) file formatsFree and lightweight alternative for seamless spreadsheet managementUser-friendly interface with zero learning curve for Excel users

microsoft office alternative - wps office

Frequently Asked Questions

Why does the Excel status bar only show Sum and not Count?

If 'Count' is not checked in the status bar customization menu, it won't display. Right-click the status bar and select 'Count' to enable it alongside Sum.

Does the status bar Count feature include empty cells?

No, the standard 'Count' feature on the status bar only tallies cells that contain data (such as text, numbers, or formulas). Completely empty cells are ignored in this quick tally.

Can I count cells based on a specific condition using the status bar?

The status bar provides a basic count of all non-empty selected cells. For conditional counting, you cannot use the status bar; instead, you should use the COUNTIF or COUNTIFS function directly within your worksheet.

Why did the Count disappear after I clicked away from my data?

The status bar statistics are dynamic and depend entirely on your current selection. If you click a single cell or an empty area, the Count will temporarily disappear until you select multiple populated cells again.

Office App Problems