September 23, 2023

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

countif excel - How to use countif in excel

1.1 Search for the number of Josh names in the table

Syntax: =COUNTIF(B2:B11,”Josh”)

countif function in excel - How to use countif in excel

The result will output a value named Josh in the data table.

countif function - How to use countif in excel

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”)

excel countif not blank - How to use countif in excel

The result will output:

countif not blank - How to use countif in excel

1.3 Find cells with values > = 10

Syntax: =COUNTIF(C2:C11,”>=10″)

countif function excel - How to use countif in excel

The result will output:

excel countif function - How to use countif in excel

Example 2: Find duplicate values ​​in the table

READ:  How to use the Excel SUBSTITUTE function

countif sophuccom 1 - How to use countif in excel

2.1 select column B

2.2

countif sophuccom 2 - How to use countif in excel

2.3

countif sophuccom 3 - How to use countif in excel

2.4

countif sophuccom 4 - How to use countif in excel

2.5

countif sophuccom 5 - How to use countif in excel

Result:

countif sophuccom 6 - How to use countif in excel

Leave a Reply

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