COUNTIF Function in Excel


Home >> How to Use Excel Tutorial >> Excel Formulas List >> COUNTIF Function in Excel



In this tutorial, you will learn about how to use the COUNTIF formula in excel. This formula is useful if you want to calculate the amount of data that fits a criterion.


Why do We Need to Learn About the COUNTIF Function in Excel?


In processing data on a spreadsheet file, sometimes we need to calculate the amount of data based on a certain criterion. This can be needed when we have much data and we want to know some data existence with a particular specification. Maybe this is needed for some processing data objectives. To get this calculation result fast, we need an automatic way to do it.

One simple example where this calculation is needed in work is when we want to see the number of late employees. To see it, we need to know the number of employees who came beyond the time when they were supposed to.

This becomes our criteria in determining the amount of data. If there are hundreds of employees, then it will be troublesome to do the counting one by one.

To help on this, there is the COUNTIF formula in excel that can be utilized. It can do the counting process fast based on the data criterion that you have. If you sometimes deal with the counting needs like that, then it is important to understand how to use it.


What is the COUNTIF Formula in Excel?


COUNTIF formula in excel is a formula to count the amount of data in a cell range that fits a certain criterion. This formula is one of the COUNT variants which have other variants like COUNTA and COUNTIFS.

Generally, the input of the COUNTIF formula in excel can be explained as follows:


=COUNTIF(range, criteria)


Note:
  • range = the cell range where you want to count the amount of data that fits with your criterion
  • criteria = the criterion as desired



How to Use the COUNTIF Excel Formula?


The following will explain how to use the COUNTIF formula in excel. In its utilization, it only needs two inputs, which are the cell range to doing the counting and your data criterion. The explanation below will be given with an excel COUNTIF example of usage in screenshots to help your understanding.


Using COUNTIF Excel Function


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

    COUNTIF Function in Excel - Screenshot of Step 1

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

    COUNTIF Function in Excel - Screenshot of Step 2

  3. Drag your cursor from the most top left to the most bottom right to input your cell range. This is where the counting will be done. Then, type comma sign ( , )

    COUNTIF Function in Excel - Screenshot of Step 3

  4. Input your criterion. The criterion must be inside quotes sign ( “” ) if it is for text or more than/less than criterion for the numbers

    COUNTIF Function in Excel - Screenshot of Step 4

  5. Type close bracket sign

    COUNTIF Function in Excel - Screenshot of Step 5

  6. Type Enter
  7. The process is done!

    COUNTIF Function in Excel - Screenshot of Step 7



Exercise


After you have learned how to use the COUNTIF formula in excel, let’s do an exercise. This is done so you can deepen your understanding of how to use the formula.

Download the exercise file and answer all the questions. Download the answer key file if you have done all the questions and want to check your answers. Or probably when you are confused on how to answer the questions!

Link to the exercise file:
Download here

Questions

Use the COUNTIF formula in excel to answer the questions below:
  1. How many times “Adi” shows up in the first column?
  2. How many empty cells in the second column?
  3. How many number data in the third column?

Link to the answer key file:
Download here


Additional Note


If there are more than one criteria for the data counting, then you need to use the COUNTIFS formula. You can learn how to use it by visiting this Compute Expert tutorial!



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