Office Settings & Configuration

Fix Excel Status Bar Showing Count Instead of Average and Sum

Amos GikundaAmos Gikunda Nov 22, 2026 868 views

Question details

The user wants Excel to show Average and Sum, as well as Count, when multiple cells are selected.

Fix Excel Status Bar Showing Count Instead of Average and Sum
Product
Microsoft Excel
Device & OS
not provided
Scenario
The user selects multiple cells in different worksheets and compares the calculations shown on the status bar.
Observed behavior
Some worksheets show Average and Sum, while others show only Count, even though the data and formatting appear identical.
Before you start

Select a range that contains at least two known numeric values and look at the status bar at the bottom of Excel. The status bar shortcut menu described below applies to desktop Excel; options may differ in other versions.

Solution 1Recommended

Enable Average and Sum on the Excel status bar

Use the status bar shortcut menu to choose which calculations Excel displays.

1
Open the status bar menu

In desktop Excel, right-click the status bar at the bottom of the workbook window.

2
Select the calculations

In the Customize Status Bar menu, select Average and Sum if they are not already checked. Leave Count selected if you also want to see the number of nonempty cells.

3
Check the display

Select a range containing numbers and look at the status bar. If the calculations are still not visible, widen the Excel window and check the selected values.

Enable Average and Sum on the Excel status bar
Free Microsoft Office alternative

Check Spreadsheet Calculations in WPS Office

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open compatible Excel workbooks in WPS Spreadsheets to continue working with your data; it does not change Excel's status bar settings.

Review selected spreadsheet data in WPS Spreadsheets.Open and edit Microsoft Excel XLS and XLSX files.Use a familiar interface for an easier transition from Microsoft Office.Work with a free, lightweight office suite.
microsoft office alternative - wps office

Frequently Asked Questions

How do I show Sum and Average on the Excel status bar?

In desktop Excel, right-click the status bar at the bottom of the window and select Sum and Average in the Customize Status Bar menu. Then select a range containing numbers.

Why does Excel show Count but not Sum for my selection?

Sum may be disabled in the status bar menu, or the selected entries may be stored as text. Right-click the status bar to check Sum, then use =COUNT(range) in an empty cell to check how many selected values are numeric.

Will changing the cell format turn text into numbers?

Not necessarily. If Excel identifies numbers stored as text, select the cells, click the warning button, and choose Convert to Number.

Does pasting values into a new sheet preserve formulas?

No. Home > Paste > Values pastes formula results rather than the formulas themselves. Use it as a test when you do not need to preserve the formulas in the pasted range.