Excel COUNTIF function — count cells that meet a condition

COUNTIF counts the cells that meet a condition — for example how many employees sold 100 or more.

In other languages: EĞERSAY (Türkçe), СЧЁТЕСЛИ (Русский)

Syntax

COUNTIF(range, criteria)

Arguments

range: The range to count.
criteria: The condition: ">=100", "Baku", "<>" (not empty) or a cell.

Example

Count the employees with sales of 100 or more.

AB

1EmployeeSales

2Aysel120

3Murad80

4Leyla150

5Orxan50

6Nigar100

Type the formula in B7

The formula in your Excel

English Excel=COUNTIF(B2:B6,">=100")
Türkçe Excel=EĞERSAY(B2:B6;">=100")
Русский Excel=СЧЁТЕСЛИ(B2:B6;">=100")

The result is 3 (120, 150 and 100).

✨ Have the AI explain this formula

Useful tips

Find duplicates: =COUNTIF($A$2:$A$100,A2)>1 — TRUE marks a duplicate.
For several conditions use COUNTIFS.

Common errors

A smaller count than expected — numbers stored as text or extra spaces in the text.