00:00There are essentially five ways to count cells. The first one starting is count A.
00:04This function counts the number of cells in a range that are not empty and it can
00:09be used to count cells that contain text and numbers. To use count A, you simply
00:13say count A and then open parentheses. I'm gonna say count this guy here and you
00:18can see there's 22 of them. If I start deleting any of this cell here, you can
00:22see that number starts to decrease. The second method of counting cell is count
00:27blank and as the name implies, it's used to count the number of blanks in your
00:32selected range here. So to use that, you say count blank and open parentheses.
00:38Let's say I'm gonna select zone for this one here and hit enter. You can see on
00:42the zone column, there's no blank. But if I start introducing blanks here, you can see
00:46the number of blanks starts to increase. The third way of counting cell is to use
00:51the function called count. It simply counts the number of cells in a range that
00:55contains number. To use the count, you call the function called count and then basically
01:01select your data set with numbers in it and you can see there's 22 of them. If you
01:05start deleting the numbers like that, you can see the numbers start decreasing. Or if
01:09you start introducing alphanumeric number here, the numbers start decreasing as well.
01:15The fourth way to count cell will be to use countif. Countif is basically a function
01:19that counts the number of cells in a range that meet a specific criteria. Generally, just
01:23one criteria. To use countif, you're gonna say count if open parenthesis and basically
01:29say I'm gonna find the zone. I'm gonna have to select the zone range here and then
01:34basically say south here like this and hit enter. You can see there's seven south.
01:38Alternatively, you can also use countif as a string itself. Countif and do the same
01:46thing again. Say north the zone again and you can use a text itself. Say maybe say east
01:51like this and you can see there's six east itself. One thing to note about countif is
01:56that this is case insensitive so you can actually make it uppercase or lowercase.
02:01I'm gonna say e, a, uppercase s and t like this and it still works because it is
02:06case insensitive. The final way to count the number of cells is to use countifs
02:10with a s. The difference between countifs and countif is that countif only allows
02:15one criteria but countifs allows multiple criteria actually to be exact 127 criteria.
02:22For this example, I'm gonna use two criteria, zone and income and the formula is
02:26countif with a s. First argument will be the zone. I'm gonna select the range for
02:32the zone here like this on my table and then the criteria is north and the second
02:36one would be the income. I'm gonna select the range for the income and the
02:40criteria would be less than or equal to 100,000 like this and close parenthesis
02:45and hit enter and that's how you count with multiple criteria.
Comments