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 sales 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.