Status Bar stats in Excel

Office for Mere Mortals
Your beginners guide to the secrets of Microsoft Office
Invalid email address
Tips and help for Word, Excel, PowerPoint and Outlook from Microsoft Office experts.  Give it a try. You can unsubscribe at any time.  Office for Mere Mortals has been running for over 20 years, we've never, ever revealed or sold subscriber details.  Privacy policy

Excel 2007 and 2010 have a quick way to see basic stats on a list of numbers.

If you only need some basic details about a list of numbers, there’s no need to use Excel formulas or the Descriptive Statistics feature.

In Excel 2003 you can select two or more cells to see a total on the Status Bar.

In Excel 2007 and Excel 2010 this is expanded to show:



  • Average/Mean
  • Count
  • Numerical Count
  • Minimum
  • Maximum
  • Sum

though not all appear on the Status bar by default.

Right-click on the Status Bar to see all the values for the current selection.   You can toggle the items that will show on the status bar.

1387 Excel 2007 Status Bar stats - Status Bar stats in Excel

subs profile e1563205311409 - Status Bar stats in Excel
Latest news & secrets of Microsoft Office

Microsoft Office experts give you tips and help for Word, Excel, PowerPoint and Outlook.

Give it a try. You can unsubscribe at any time.  Office Watch has been running for over 20 years, we've never, ever revealed or sold subscriber details.  Privacy policy
Invalid email address