Bummer! This is just a preview. You need to be signed in with a Basic account to view the entire video.
The COUNT Function1:02 with Michael Watson
The COUNT function lets you determine how many numbers are in a group of cells. It only counts the cells that actually contain a number, so empty cells (or cells with text) are ignored in the count.
- you can continue to use the spreadsheet from the last video, or
- open a copy of this spreadsheet to catch up to this video
The count function will tell you how many cells you have selected.
It does not sum up the numbers.
It tells you how many there are.
Sometimes you may have a group of cells that contain numerical and text values.
Here we're looking at a sheet that has months and
the total number of transacted sales that occurred in that month.
Let's look at count in the context of this spreadsheet.
So, I'm selecting, All 12 months, and it returns back 12.
It's not the sum or the total of all the sales that occurred over the year.
It's the number of sales that have been selected.
This is a simple example.
But notice that if I change this formula so
that it selects column A as well, the value doesn't change.
That's because even though there's 24 cells that have been selected,
it shows 12 because there's only 12 cells with numbers.
Sometimes I use count to spot check that I've selected the right amount of columns
You need to sign up for Treehouse in order to download course files.Sign up