Office Settings & Configuration

How to Restore Sum and Average on the Excel Status Bar

Rana GarciaRana Garcia Nov 10, 2026 872 views

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.

How to Restore Sum and Average on the Excel Status Bar
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.
Before you start

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.

Solution 1Recommended

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.

1
Select Numeric Cells

Open your Excel worksheet and highlight at least two cells that contain numbers.

2
Locate the Status Bar

Move your cursor to the bottom edge of the Excel window where the gray or green status bar is located.

3
Open Customize Status Bar

Right-click anywhere in the empty space on the status bar to open the 'Customize Status Bar' drop-down menu.

4
Enable Calculations

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.

Enable Status Bar Calculations via Right-Click Menu
Data Format Verification: If you have enabled these settings but the Sum and Average still do not appear, verify that your selected cells are formatted as Numbers and not as Text.
Quick Spreadsheet Solutions

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. 1. Open your workbook in WPS Spreadsheet: Launch WPS Office and open the spreadsheet containing your numeric data.
  2. 2. Highlight numeric cells: Click and drag to select two or more cells containing the numbers you wish to summarize.
  3. 3. Check the status bar: Look at the bottom right corner of the WPS window to instantly view the Average, Count, and Sum.
  4. 4. Customize your view: Right-click the status bar to easily toggle which specific calculations (like Max or Min) are displayed.
Instantly view Sum, Average, and Count on the customizable status barFully compatible with Microsoft Excel (.xlsx and .xls) formatsLightweight application that runs smoothly on all operating systemsFree to download and use with a familiar user interface
QA img-9

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.