The Status bar: Sum, Count, Average guide
Select a range and the status bar under the grid shows its Average, Count and Sum, no formula needed. Right-click the status bar to add Numerical Count, Min and Max.
A quick check, not a formula
When you need a number once, to answer a question or check a total, select the cells and look down. Nothing is written into the sheet, so nothing needs deleting afterwards. When the number has to stay and update, write a formula instead: SUM, COUNT.
What each figure counts
- Sum, Average, Min and Max use only the cells that hold numbers.
- Count counts every filled cell, text included, like COUNTA. A header in the selection makes it one too many.
- Numerical Count counts only the numbers, like COUNT.
So when Count and Numerical Count differ, something in the selection isn't a number: a header, a note, or a number stored as text that Sum is quietly leaving out.
Add Min and Max
Right-click the status bar and tick the figures you want; Excel keeps the choice. Average, Count and Sum are on by default. Excel for the web shows the same six figures.
Common mistakes
- Selecting the header. Count goes up by one.
- A selection that stops early. Sum looks plausible and is short. Check Count against the number of rows.
- No Sum at all. Either the cells hold numbers stored as text, or Sum was unticked in the right-click menu.
FAQ
- How do I see the sum of selected cells in Excel?
- Select them and look at the status bar at the bottom of the window: it shows Sum, Count and Average. If Sum is missing, right-click the status bar and tick it.
- Why does the Excel status bar not show the sum?
- Either Sum is unticked (right-click the status bar to turn it on), or the cells hold numbers stored as text, which the status bar counts but doesn't add.
- What is the difference between Count and Numerical Count on the status bar?
- Count is every filled cell, text included. Numerical Count is only the cells with numbers.
- How do I show Max on the Excel status bar?
- Right-click the status bar and tick Maximum (Max). Minimum works the same way.



































































