1
00:00:00,243 --> 00:00:03,708
The count function will tell you
how many cells you have selected.

2
00:00:03,708 --> 00:00:05,860
It does not sum up the numbers.

3
00:00:05,860 --> 00:00:07,940
It tells you how many there are.

4
00:00:07,940 --> 00:00:12,050
Sometimes you may have a group of cells
that contain numerical and text values.

5
00:00:12,050 --> 00:00:15,040
Here we're looking at
a sheet that has months and

6
00:00:15,040 --> 00:00:18,680
the total number of transacted
sales that occurred in that month.

7
00:00:18,680 --> 00:00:23,670
Let's look at count in
the context of this spreadsheet.

8
00:00:23,670 --> 00:00:32,380
So, I'm selecting, All 12 months,
and it returns back 12.

9
00:00:32,380 --> 00:00:36,420
It's not the sum or the total of all
the sales that occurred over the year.

10
00:00:36,420 --> 00:00:39,950
It's the number of cells
that have been selected.

11
00:00:39,950 --> 00:00:41,160
This is a simple example.

12
00:00:41,160 --> 00:00:44,210
But notice that if I
change this formula so

13
00:00:44,210 --> 00:00:49,860
that it selects column A as well,
the value doesn't change.

14
00:00:49,860 --> 00:00:54,000
That's because even though there's
24 cells that have been selected,

15
00:00:54,000 --> 00:00:57,210
it shows 12 because there's
only 12 cells with numbers.

16
00:00:57,210 --> 00:01:00,740
Sometimes I use count to spot check that
I've selected the right amount of columns

17
00:01:00,740 --> 00:01:01,310
or rows.