How to use countif in excel

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, 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

countif - sophuccom - 1

2.1 select column B










Add a Comment

Your email address will not be published. Required fields are marked *