How to Count Cells in Microsoft Excel (COUNT, COUNTA, COUNTIF, COUNTIFS Functions) - Excel Tips and Tricks - video Dailymotion

RobertBarone

Learn how to count cells in Microsoft Excel (COUNT, COUNTA, COUNTIF, COUNTIFS Functions).   Discover 5 ways to count cells in a range of data in Excel. I will explore wow do I count cells by text in Excel, and explain what is the formula to count cells?  We will look at how to count cells with specific text, count cells with text or numbers, count cells with numbers and count number of cells in range.  We will also visit countifs function in excel, how to count specific names in excel and the countif formula.   In Excel, there are several ways to count cells:   COUNT: This function counts the number of cells in a range that contains numbers.  =COUNT(C2:C23)   COUNTA: This function counts the number of cells in a range that are not empty. It can be used to count cells that contain text, numbers, or formulas.  =COUNTA(A2:A23)   COUNTBLANK: This function counts the number of cells in a range that are empty.  =COUNTBLANK(A2:A23)   COUNTIF: This function counts the number of cells in a range that meet a specified criterion. For example, you could use COUNTIF to count the number of cells that contain a certain text string.  =COUNTIF(B2:B23,"North")   COUNTIFS: This function is similar to COUNTIF, but it allows you to specify multiple criteria. It counts the number of cells in a range that meet all of the specified criteria.  =COUNT(C2:C204)     =COUNTA(A2:A23)   =COUNTBLANK(A2:A23)   =COUNT(C2:C23)   =COUNTIF(B2:B23,E18)   =COUNT(C2:C204)    How to Count Cells in Microsoft Excel, COUNT, COUNTA, COUNTIF, COUNTIFS,  How do I count cells by text in Excel?,What is the formula to count cells?,How do I total rows in Excel?,How do you count values in a column in Excel?,Ways to count cells in a range of data,  excel count cells with specific text,excel count cells with text or numbers,excel count cells with numbers,excel count number of cells in range,countifs function in excel,how to count specific names in excel,countif formula,excel count how many times a value appears in a column,  excel count cells with text,excel count cells with specific text,excel count cells with text or numbers,excel count cells with numbers,excel count number of cells in range,countifs function in excel,

Transcript

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.

How to Count Cells in Microsoft Excel (COUNT, COUNTA, COUNTIF, COUNTIFS Functions) - Excel Tips and Tricks

Category

Transcript

Be the first to comment

Recommended