Here we have test score data for a group of students.
Let’s use thestatus barto look at the information shown in column J.
First note that the status bar can be customized to display different information.
Just right-click to show 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 99 test scores total.
In this case, it’s blank.
Average works like you’d expect.
you could get the Maximum and Minimum values in exactly the same way.
it’s possible for you to 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.
However, the sum of date values probably isn’t something you’re gonna wanna know.
