Fix Excel Status Bar Showing Count Instead of Average and Sum
Question details
The user wants Excel to show Average and Sum, as well as Count, when multiple cells are selected.

- 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.
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.
Enable Average and Sum on the Excel status bar
Use the status bar shortcut menu to choose which calculations Excel displays.
In desktop Excel, right-click the status bar at the bottom of the workbook window.
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.
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.

Check whether the selected values are stored as numbers
Use this check when Average and Sum are enabled but only Count appears for a particular range.
Test the affected worksheet in a new workbook
Use a clean workbook to determine whether the behavior is associated with the original workbook or worksheet.
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.

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.




