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:**