Count Function in Excel


Home >> How to Use Excel Tutorial >> Excel Calculations >> 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

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

    Count Function in Excel - Screenshot of Step 1-1

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

    Count Function in Excel - Screenshot of Step 1-2

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

    Count Function in Excel - Screenshot of Step 1-3

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

    Count Function in Excel - Screenshot of Step 1-4

  5. Press Enter
  6. The process is done!

    Count Function in Excel - Screenshot of Step 1-6




Using COUNTA

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

    Count Function in Excel - Screenshot of Step 2-1

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

    Count Function in Excel - Screenshot of Step 2-2

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

    Count Function in Excel - Screenshot of Step 2-3

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

    Count Function in Excel - Screenshot of Step 2-4

  5. Press Enter
  6. The process is done!

    Count Function in Excel - Screenshot of Step 2-6




Menggunakan Rumus Excel COUNTBLANK

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

    Count Function in Excel - Screenshot of Step 3-1

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

    Count Function in Excel - Screenshot of Step 3-2

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

    Count Function in Excel - Screenshot of Step 3-3

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

    Count Function in Excel - Screenshot of Step 3-4

  5. Press Enter
  6. The process is done!

    Count Function in Excel - Screenshot of Step 3-6




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.

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

    Count Function in Excel - Screenshot of Step 4-1

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

    Count Function in Excel - Screenshot of Step 4-2

  3. 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 ( , )

    Count Function in Excel - Screenshot of Step 4-3

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

    Count Function in Excel - Screenshot of Step 4-4

  5. Type close bracket sign

    Count Function in Excel - Screenshot of Step 4-5

  6. Type Enter
  7. The process is done!

    Count Function in Excel - Screenshot of Step 4-7




Using COUNTIFS

COUNTIFS has similar function with COUNTIF. The only difference is you will use COUNTIFS if your criterias are more than one

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

    Count Function in Excel - Screenshot of Step 5-1

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

    Count Function in Excel - Screenshot of Step 5-2

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

    Count Function in Excel - Screenshot of Step 5-3

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

    Count Function in Excel - Screenshot of Step 5-4

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

    Count Function in Excel - Screenshot of Step 5-5

  6. Type close bracket sign after all have already been inputted

    Count Function in Excel - Screenshot of Step 5-6

  7. Type Enter
  8. The process is done!

    Count Function in Excel - Screenshot of Step 5-8



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

  1. How many cells filled in those four columns?
  2. How many are empty?
  3. 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))




Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!


Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!



Follow our tutorial content also on


CONTACT US PRIVACY POLICY TERMS AND CONDITION AFFILIATE DISCLOSURE @Compute Expert