Here’s a neat trick that will allow you to see “at-a-glance” summary statistics for any range you highlight in Excel. With this you’ll be able to see a calculated average, count, minimum, maximum and sum for any range with numerical values.

 

Step-001-How-To-Enable-Status-Bar-Summary-Statistics How To Enable Status Bar Summary Statistics

 

Enable the summary statistics.

  1. Right click on the status bar.
  2. Select the items you would like to see.
  3. Highlight a range of numbers and the summary statistics for that range will appear in the status bar.

 

Wow, the average salary for the Galactic Empire is $5,890,400, sign me up!

 

Status-Bar-Summary-Statistics How To Enable Status Bar Summary Statistics