Exceljet

Quick, clean, and to the point

How to use the status bar for quick calculations

In this video, we'll take a quick look at the information provided by the status bar

The status bar provides real-time data about currently selected cells and can give you a lot of good information without the need to write any formulas.

Here we have test score data for a group of students

Let's use the status bar to look at the different information shown in column J.

First note that the status bar can be customized to display different information. Just right click to display available options. You'll find the statistical information grouped together.

Let's look first at Count. Count will count all cells that contain values, numeric or otherwise.

Using count, we can see that there are 20 people in this list, and 100 scores. Could is a easy way to see how many rows you have selected, as long as those rows contain data.

If we switch to count numbers, we see that one of the test scores is non-numeric. Count numbers only counts values, so even if we select the names as well, we still get a count of 99.

Average works like you'd expect. You can quickly see the average for all of one student's test scores, or get the average for one particular test. You can include as many scores as you like, and even use the control-ley to add non-contiguous selections.

You can get the Maximum and Minimum values in exactly the same way.

You can also see the sum of numeric information in the status bar.

Note that Excel will sum numeric information even when it doesn't make sense.

The sum of one student's test scores night be something you want to know. Or the some of some costs.

However, the sum of date values probably isn't something you need to know.

Finally, not that you can display more than one type of data at the same time. For example, I can set the status bar to show count, sum, and average and this information will appear whenever I make a selection.

Course 
Core Formula

Related shortcuts

Author 
Dave Bruns