The COUNTIF function is a conditional counting function in Excel. You can use the COUNTIF function to count duplicate cells, counting data. Here is the syntax of the COUNTIF function and some illustrative examples for you to understand how to use this basic Excel function.
Normally COUNTIF function will be used with statistical data tables, requiring counting the number of cells containing values that satisfy a given condition. The syntax of the COUNTIF function is also quite simple, you only need to look through it once, see the examples below of Sophuc.com, you will surely know how to do it.
How to use countif in excel
Use COUNTIF, one of the statistical functions, to count the number of cells that meet a criterion; for example, to count the number of times a particular city appears in a customer list.
In its simplest form, COUNTIF says:
=COUNTIF(Where do you want to look?, What do you want to look for?)
Example 1: We will learn how to use the COUNTIF function with the data table below and various data search examples.
1.1 Search for the number of Josh names in the table
Syntax: =COUNTIF(B2:B11,”Josh”)
The result will output a value named Josh in the data table.
1.2 Find the number of non-Harry rows in the table
We use the condition that the name other than Lemons is “<>Harry” and then enter the formula
Syntax: =COUNTIF(B2:B11,”<> Harry”)
The result will output:
1.3 Find cells with values > = 10
Syntax: =COUNTIF(C2:C11,”>=10″)
The result will output:
Example 2: Find duplicate values in the table
2.1 select column B
2.2
2.3
2.4
2.5
Result: