One of the handiest and most frequently used features in Microsoft Excel is the automatic summary statistics displayed in the bottom-right status bar. Highlighting a range of cells with your mouse normally provides instantaneous calculations for Sum, Average, and Count without requiring you to write a formula. When you highlight a column of numbers and the status bar remains completely empty—or only displays a basic “Count” while omitting Sum and Average—your workflow slows to a crawl. Rather than an Excel application glitch, this usually happens because numerical values are accidentally stored as text, or specific statistical metrics were unchecked in the status bar configuration.
Customise and Re-enable Status Bar Statistics
The status bar in Excel is fully configurable, allowing users to toggle individual mathematical summaries on or off. If another user unticked Sum or Average, or if a software update reset your interface preferences, re-enabling them takes just two clicks.
- Open your spreadsheet in Microsoft Excel.
- Highlight any range containing visible numbers.
- Move your cursor to the bottom edge of the Excel window and right-click anywhere on the thin status bar.
- In the Customise Status Bar context menu that appears, review the active options.
- Ensure that checkmarks appear next to:
- Average
- Count
- Numerical Count
- Minimum (optional)
- Maximum (optional)
- Sum
- If Sum or Average lacks a checkmark, click on them to re-activate them.
Once ticked, Excel will immediately calculate and display mathematical totals whenever you select two or more cells.
Convert “Numbers Stored as Text” to Real Numbers
If Sum and Average are already enabled in the right-click menu but the status bar still refuses to show mathematical results (or only displays “Count”), your numbers are formatted as text strings. Excel strictly ignores text strings when calculating sums and averages.
- Look closely at your selected cells; if you see tiny green error triangles in the upper-left corners of the cells, Excel has flagged them as text.
- Highlight the entire range of numbers.
- Click the yellow warning diamond (Exclamation mark) that appears beside the first selected cell.
- From the drop-down action list, click Convert to Number.
- Your numbers will immediately re-align to the right side of the cells, and the status bar will display the accurate Sum and Average.
Converting text values to legitimate integers or decimals allows Excel’s calculation engine to evaluate the numbers instantly.
Use “Paste Special Multiply” to Force Numeric Recognition
Data imported from accounting software, CRM systems, or CSV files often contains invisible non-breaking spaces or text formatting that prevents the standard conversion prompt from appearing.
- Click on an empty, unformatted cell anywhere on your worksheet and type the number
1. - Press Ctrl + C to copy that cell.
- Highlight the entire column or range of numbers that Excel refuses to sum.
- Right-click the selected range and choose Paste Special… (or press Ctrl + Alt + V).
- Under the Operation section of the dialogue box, select Multiply.
- Click OK.
Multiplying text numbers by 1 forces Excel to re-evaluate every cell mathematically without changing its underlying value, instantly restoring your status bar totals.
Remove Leading Apostrophes and Hidden Formatting
Leading single quotation marks (apostrophes) placed before digits instruct Excel to treat the cell contents as raw literal text, completely suppressing calculation.
- Highlight your column of numbers.
- Click on the Data tab on the Excel ribbon and click Text to Columns.
- In the wizard that appears, select Delimited and click Finish immediately without altering any delimiter choices.
Running the Text to Columns wizard strips away hidden leading apostrophes and resets the column to general numeric data.