Fix Missing Sum and Average on the Excel Status Bar
Question details
The user needs Excel to show Sum and Average for selected cells on the status bar.

- Product
- Microsoft Excel 2016
- Device & OS
- Windows 10
- Scenario
- Selecting cells in a workbook to view quick calculations on the Excel status bar.
- Observed behavior
- The status bar shows Count but not Sum or Average, even though both options are enabled. The same workbook works on another computer, and reinstalling Office and Windows did not resolve the issue.
Open the affected workbook and right-click the Excel status bar to confirm that Sum and Average are checked. Keep the working computer available for comparison if possible.
Check Whether the Selected Cells Contain Numbers
Use this check to distinguish a data-type issue from a problem with Excel on the affected computer.
Open a blank worksheet, enter 10 and 20 in two adjacent cells, and select both cells. Check the status bar for Sum and Average.
In a blank cell, enter =ISNUMBER(A1), replacing A1 with an affected cell reference. FALSE means the cell does not contain a numeric value; a formula may be returning text.
If affected cells contain numbers stored as text, select those cells and use Data > Text to Columns > Finish. For formulas that return text, edit the formula so it returns a numeric value instead.
Select the same contiguous range on both computers. If the original selection includes filtered rows or separate ranges, test a simple adjacent range as well.

Compare Regional Settings and Excel Versions
Use this method if the workbook works on another computer but numbers are interpreted differently on Windows 10.
Test Excel in Safe Mode for Add-In Conflicts
Use this test if Sum and Average are still missing for simple numeric cells.
Work With Excel Spreadsheets in WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open compatible Excel files and continue working with calculations while migrating your documents to WPS Office.

Frequently Asked Questions
Why does Excel show Count but not Sum or Average?
Count can include nonempty text cells, but Sum and Average need numeric values. Test an affected cell with =ISNUMBER(A1), replacing A1 with its reference.
Where can I enable Sum and Average on the status bar?
Right-click the status bar at the bottom of Excel and make sure Sum and Average are checked in the customization menu.
How can I tell whether the problem affects every workbook?
Open a blank worksheet, enter 10 and 20 in adjacent cells, and select both. If Sum and Average also fail to appear there, investigate Excel settings or add-ins.
Could regional settings affect how Excel reads my numbers?
Yes. Decimal and thousands separators can affect whether values are recognized as numbers. Compare Windows Settings > Time & Language > Region and Excel's File > Options > Advanced settings with the working computer.
How do I check whether an Excel add-in is causing the issue?
Press Windows + R, enter excel /safe, and test a numeric selection. If it works in Safe Mode, review add-ins under File > Options > Add-ins in a normal Excel session.




