'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Fix Missing Sum, Count, and Average in Excel for Mac Status Bar
Question details
The user needs to restore the Sum, Count, and Average metrics on the Excel status bar, which are no longer displaying despite being enabled in the settings.
- Product
- Microsoft Excel for Mac (v16.72)
- Device & OS
- macOS 12.6.5
- Scenario
- Attempting to view quick statistical summaries of data directly on the status bar without writing spreadsheet formulas.
- Observed behavior
- Sum, Count, and Average do not appear on the status bar even when the calculation options remain actively selected in the customization menu.
Right-click the status bar at the bottom of your Excel window to verify that Average, Count, and Sum are actively checked in the Customize Status Bar menu.
Select a Valid Range of Multiple Cells
Excel requires you to select at least two cells containing numerical data to calculate and display these status bar metrics.
Excel is designed to display status bar calculations only when an appropriate range of data is highlighted. If you select a single cell, blank cells, or text cells, the numerical metrics will temporarily disappear from the status bar.
Ensure that the cells you are working with contain valid numbers rather than text strings or blanks.
Click and drag your mouse to select at least two adjacent cells, or hold down the Command key and click to select non-adjacent cells.
Look at the bottom right corner of the Excel window to view the restored Sum, Count, and Average metrics.
Report the Software Defect to Microsoft
If selecting multiple cells with data does not restore the calculations, the issue may be a known software bug in Excel 16.72.
Try WPS Spreadsheet for Reliable Quick Calculations
If persistent bugs in Microsoft Excel for Mac disrupt your workflow, consider switching to WPS Office. It provides a lightweight, highly stable environment where essential features like status bar calculations work flawlessly right out of the box.
- 1. Install the software: Download and install the free WPS Office suite for your Mac.
- 2. Open your spreadsheet: Launch WPS Spreadsheet and seamlessly open your existing Excel (.xlsx) files.
- 3. Highlight and calculate: Select two or more cells with data to instantly view the Sum, Count, and Average on the bottom status bar.
Frequently Asked Questions
Why did the Sum, Count, and Average suddenly disappear from my Excel status bar?
These metrics naturally disappear if you select only one cell or if you highlight cells that do not contain numerical data. They can also disappear if the display options were accidentally unchecked in the status bar menu, or due to occasional software bugs in specific Excel for Mac updates.
How do I customize what shows up on the Excel status bar?
Right-click (or Control-click) anywhere on the status bar at the bottom of the Excel window. This action opens the 'Customize Status Bar' context menu, where you can easily toggle options like Average, Count, Numerical Count, Minimum, Maximum, and Sum on or off.
Can I view the sum of non-adjacent cells on the status bar?
Yes. Hold down the Command key on your Mac keyboard while clicking individual, non-adjacent cells across your worksheet. As long as you select two or more cells containing numbers, Excel will aggregate them and display the total sum on the status bar.
