MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel 2020: Power Up the Status Bar Statistics

February 03, 2020 - by Bill Jelen

Power up status bar: Photo by Victor Freitas on Unsplash

When you select two or more numeric cells, the total appears in the status bar in the lower right of the Excel window. When you see a total, right-click and choose Average, Count, Numerical Count, Minimum, Maximum, and Sum. You can now see the largest, smallest, and average just by selecting a range of cells:

A range of numeric cells is selected. The status bar is showing statistics: Average, Count, Numerical Count, Min, Max, Sum.

Thanks to Al Momrik for status bar.

Title Photo: Victor Freitas on Unsplash

This article is an excerpt from MrExcel 2020 - Seeing Excel Clearly.

Bill Jelen is the author / co-author of
MrExcel 2020 - Seeing Excel Clearly

This is a 4th edition of MrExcel LX. Updates for 2020 include: Ask a question about your data, XLOOKUP, Power Query's Data Profiling tools, How Geography Data Types decide which Madison, A SEQUENCE example for descending 52 weeks, Exchange Rates support in Stock Data Types, How to collapse the Search box, How to leave effective feedback for Microsoft, How to post your worksheet to the MrExcel Board using XL2BB.