Using Quick Calculations

The status bar appears at the bottom of the Excel window and you are most likely familiar with finding settings like your zoom control here.  Naturally, there is far more use to the status bar than just zooming, and one of those things is activating the quick calculations.

These quick calculations are useful when you want to spot check values but don't necessarily need the resulting value to be placed as an independent value on the spreadsheet.

Right click onto the status bar.  This will display all the content that you could have displayed if you wish.  There is a section that is specifically for the quick calculations - typically Sum is already selected.  You may select any calculation types you like.

When you next select a range of cells containing values, the status bar will display the quick calculations that you have requested.