Calculation Issues

Fix Missing Sum and Average on the Excel Status Bar

Huma Ashraf ChHuma Ashraf Ch Nov 13, 2026 870 views

Question details

The user needs Excel to show Sum and Average for selected cells on the status bar.

Fix Missing Sum and Average on the Excel 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.
Before you start

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.

Solution 1Recommended

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.

1
Test a simple selection

Open a blank worksheet, enter 10 and 20 in two adjacent cells, and select both cells. Check the status bar for Sum and Average.

2
Check the affected values

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.

3
Convert text numbers

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.

4
Compare the selection

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.

Check Whether the Selected Cells Contain Numbers
Check number formats: Count can include nonempty text cells, while Sum and Average require numeric values. Converting text may also depend on the decimal and thousands separators used in the data.
Free Microsoft Office alternative

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.

Open and edit spreadsheets in Microsoft Excel XLSX and XLS formatsWork with formulas and numeric data in WPS SpreadsheetUse a familiar interface that makes switching from Office easierGet a free, lightweight office suite
microsoft office alternative - 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.