Count Function in Excel
In this tutorial part, you will learn about count function in excel. The count function in excel can be done by using various formulas in the form of COUNT formula in excel extension. You will master the usage of count function in excel by learning from the tutorial points in this article.
Why We Need to Learn About Count Function in Excel?
In doing analysis, sometimes we want to know how large our data collection is so we know whether the collection process done for the data is already complete and representative in terms of results or probably using it as divider for further data processing. Getting the understanding about how big the data we have also helps in determining data percentage and segmentation proportion, which is often used in research result analysis that then can be analyzed to decide the step or policy that we must take in our daily job or business.
If we often do data processing in this spreadsheet tool, then understanding about count formula in excel is something which is very important to do. This is important because the result is often used in further analysis through other kinds of calculation in this spreadsheet software, like the calculation for percentage, data normalization, proportion assignment, and others. Because of that, if you want to be an expert in data processing, please get the understanding about how to use the various extensions of COUNT formula in excel by reading this tutorial!
What is Count Function in Excel?
Count function in excel is the method to calculate how much data do we have, in general or in specific parts of it with some criterias. In its practice, the extensions of COUNT formula in excel like COUNTA, COUNTBLANK, COUNTIF, and COUNTIFS will much help in doing the process if you often analyze using this spreadsheet tool. This count formula in excel will calculate the size of data from the cell range given as input.
How to Use Count Function in Excel?
Next part will describe about taking advantage of count function in excel by using the extensions of COUNT formula in excel which are: COUNT, COUNTA, COUNTBLANK, COUNTIF, and COUNTIFS. Each of these count function in excel has its unique usage with the explanation as follows:
 COUNT, count formula in excel to calculate the amount of numbers in a cell range
 COUNTA, count formula in excel to calculate the amount of filled cells in a cell range
 COUNTBLANK, count formula in excel to calculate the amount of empty cells in a cell range
 COUNTIF, count formula in excel to calculate the amount of data with one specific criteria in a cell range
 COUNTIFS, count formula in excel to calculate the amount of data with more than one specific criteria in a cell range
Count function in excel using the methods above will be explained in details below
Using COUNT Formula in Excel

Type equal sign ( = ) in the cell where you want to put the result in

Type COUNT (can be with large and small letters) and open bracket sign after =

Drag cursor from the most top left to the most bottom right on the cells where you want to calculate the amount of numbers are. You can also type comma sign ( , ) and add cell range in another place until all of them are in the formula

Type close bracket sign after all that you want to be processed have already been inputted
 Press Enter

The process is done!
Using COUNTA

Type equal sign ( = ) in the cell where you want to put the result in

Type COUNTA (can be with large and small letters) and open bracket sign after =

Drag cursor from the most top left to the most bottom right on the cells where you want to calculate the amount of filled cells are. You can also type comma sign ( , ) and add cell range in another place until all of them are in the formula

Type close bracket sign after all that you want to be processed have already been inputted
 Press Enter

The process is done!
Menggunakan Rumus Excel COUNTBLANK

Type equal sign ( = ) in the cell where you want to put the result in

Type COUNTBLANK (can be with large and small letters) and open bracket sign after =

Drag cursor from the most top left to the most bottom right on the cells where you want to calculate the amount of blank cells are. You can also type comma sign ( , ) and add cell range in another place until all of them are in the formula

Type close bracket sign after all that you want to be processed have already been inputted
 Press Enter

The process is done!
Using COUNTIF
COUNTIF can be used if you have a specific criteria for the data you want to calculate the amount of. This count function is useful if you have a table with many data and you need to know the amount of only some data from it with a particular condition for them.
Type equal sign ( = ) in the cell where you want to put the result in

Type COUNTIF (can be with large and small letters) and open bracket sign after =

Drag cursor from the most top left to the most bottom right on the cells where you want to calculate the amount of data with criteria are then type comma sign ( , )

Type your data criteria. The criteria must be inside quote sign ( “” ) if it is in form of text or more than/less than condition for the numbers

Type close bracket sign
 Type Enter

The process is done!
Using COUNTIFS
COUNTIFS has similar function with COUNTIF. The only difference is you will use COUNTIFS if your criterias are more than one
Type equal sign ( = ) in the cell where you want to put the result in

Type COUNTIFS (can be with large and small letters) and open bracket sign after =

Drag cursor on the cell range in a column/row where your data is and type comma sign ( , )

Type your data criteria. The criteria must be inside quote sign ( “” ) if it is in form of text or more than/less than condition for the numbers

Type comma sign, drag cursor on the cell range for the next column/row of data place, type comma sign again, and type data criteria for this cell range if there are still cell range and criteria which are needed to be inputted. The additional cell range must be inline vertically/horizontally with the previous input and should have the same number of cells

Type close bracket sign after all have already been inputted
 Type Enter

The process is done!
Exercise
After you have learned count function in excel with the usage of extensions of count formula in excel explained above, you can practice your understanding to those extensions of count formula in excel by using them in this exercise!
Download file from the link below and answer the questions. Download the answer after you have practiced the count formula in excel and sure about the answer!
Download link to practice your understanding of count function in excel:
Download here
Questions
 How many cells filled in those four columns?
 How many are empty?
 How many data with the criteria: region 1, product C, and sold more than 100?
Download link for answer:
Download here
Additional Notes
 In using count function in excel (COUNT, COUNTA, and COUNTBLANK), drag cell cursor and numbers or cell coordinates input with comma sign separation can be done in one writing
 If you want, cell coordinates which are near to each other for count function in excel can also be written manually separated for the most top left cell and most bottom right cell by two dots sign ( : ) (e.g. COUNTA(B1:D25))