This tip helps you discover how to quickly display statistics on the status bar by simply highlighting data.
You are welcome to download the workbook to practice.
Applies To: Microsoft® Excel® for Windows 2010, 2013, and 2016.
Excel allows for up to 6 statistic options to be viewed on the status bar, namely; Average, Count, Numeric Count, Minimum, Maximum, and Sum.
In order to view the stats, you will need to right click on the status bar and click to enable the stats option you would like to see on the status bar.
Once you highlight the data, the status bar will show the stats.
This allows you to easily view stats without having to write a formula.
The post How to view statistics on the status bar in Excel appeared first on Sage Intelligence.
Powered by WPeMatico