How to Restore Sum and Average on the Excel Status Bar
Question details
The user needs to re-enable the Sum and Average calculations that usually appear on the Excel status bar when selecting multiple numeric cells.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Viewing quick mathematical summaries for selected numeric cells without writing formulas.
- Observed behavior
- The Excel status bar no longer displays the Sum and Average metrics when numeric cells are highlighted.
Ensure you have selected at least two cells containing valid numeric data, as Sum and Average calculations will only display when multiple numbers are highlighted.
Enable Status Bar Calculations via Right-Click Menu
Use the built-in Customize Status Bar menu to quickly re-enable missing mathematical summaries like Sum, Average, and Count.
Excel allows users to toggle various informational displays on the status bar. If Sum and Average are missing, they were likely unchecked accidentally from this customization menu.
Open your Excel worksheet and highlight at least two cells that contain numbers.
Move your cursor to the bottom edge of the Excel window where the gray or green status bar is located.
Right-click anywhere in the empty space on the status bar to open the 'Customize Status Bar' drop-down menu.
Look for the 'Average' and 'Sum' options in the list and click them to ensure a checkmark appears next to each. The calculations will instantly reappear on the status bar.

Easily View Sum and Average on the Status Bar in WPS Spreadsheet
WPS Spreadsheet offers an intuitive interface where you can instantly view and customize status bar calculations. It is completely free, highly compatible with Microsoft Excel files, and ensures your workflow remains uninterrupted.
- 1. Open your workbook in WPS Spreadsheet: Launch WPS Office and open the spreadsheet containing your numeric data.
- 2. Highlight numeric cells: Click and drag to select two or more cells containing the numbers you wish to summarize.
- 3. Check the status bar: Look at the bottom right corner of the WPS window to instantly view the Average, Count, and Sum.
- 4. Customize your view: Right-click the status bar to easily toggle which specific calculations (like Max or Min) are displayed.

Frequently Asked Questions
Why does my Excel status bar only show 'Count' and not 'Sum'?
This usually happens if the selected cells are formatted as Text instead of Numbers. Excel cannot calculate the sum or average of text strings. To fix this, change the cell format to Number or General, and re-enter the data if necessary.
Does the status bar calculate hidden cells in Excel?
Yes, by default, the status bar calculates all highlighted cells, including those located in hidden rows or columns. If you only want to calculate visible cells, you will need to select only the visible cells using the 'Go To Special' menu.
Can I copy the Sum or Average value directly from the status bar?
Yes. In modern versions of Excel and WPS Spreadsheet, you can simply click directly on the Sum, Average, or Count value displayed on the status bar. This action automatically copies the value to your clipboard so you can paste it anywhere.
Why is my Excel status bar missing completely?
Your status bar might be hidden because you are in Full Screen mode, or it may have been disabled via a macro/VBA script. Try pressing ESC to exit full screen mode, or restart your spreadsheet application.




