Clever Clogs tip # 706
30 June 2022

Add more automatic calculations to your Status Bar (Microsoft Excel) *

You probably know you can see - and nowadays also copy - the Average, Count and Sum in the Status Bar in Excel. Simply select two or more cells and look in the bottom right hand corner.

But did you know that you can add additional calculations you might find helpful such as Numerical Count, Minimum and Maximum?

Here's how:

  1. Right-click anywhere in the Status Bar.
  2. Select the options you want to add such as Numerical Count, Minimum and Maximum.

Maximum finds the largest number and Minimum the smallest. Count shows the number of cells that are not empty, whereas Numerical Count shows the number of cells that are not empty that contain numbers, ignoring text.

Oh, and Microsoft recently rolled out the functionality that you can copy the value from the Status Bar. Simply click the number. (No right-click!) I believe it only tells you once that it's been copied to your clipboard. So far the only time I've used it was to quickly copy a sum in an email. But perhaps you find it helpful.

Related tips

  1. Quick way to paste content of the clipboard into an email message: tip_519.php
  2. Using AutoCalculate to compute summary and statistical information in a worksheet: tip_26.html

This week's CleverClogsTipTime on LinkedIn, in case you missed it ...

  1. Stick Email on your Quick Access Toolbar!
  2. Stop googling everything

* Unless stated otherwise this tip is written for Microsoft 365 desktop apps and Windows 10 users, but might also be useful in Office 2010, 2013 and 2016.