Use Excel’s Status Bar to quickly see Sum, Avg & Count!

The status bar automatically gives you the sum, average and count of any data you highlight by default!

In the example below – I’ve highlighted some temperature values. At the bottom, the status bar has automatically given me numbers for the average of those values, the count and the sum! These numbers would change if I highlight different values.

You can customize what’s shown in the status bar as well. Just right click on the status bar and you can customize the values shown (including min, max and numerical count (cells that have numbers in them).

So, the next time you need a quick sum of numbers, highlight the data

you need and look no further than the status bar in Excel!