Excel COUNTIF Function: How to Use It, with Examples
Turkish: EĞERSAY

Counts the cells that meet a condition, for example how many rows are from Ankara.

COUNTIF syntax

=COUNTIF(range, criteria)

In Turkish Excel: =EĞERSAY(aralık; ölçüt)

ArgumentDescription
rangeThe cells to count.
criteriaThe condition.

COUNTIF examples

Sample table:

ABCD
1ProductRegionQuantityPrice
2PenAnkara125
3Notebookİzmir820
4EraserAnkara302
5NotebookAnkara520
6Penİzmir75
=COUNTIF(B2:B6,"Ankara")
Result: 3

Number of rows with Ankara.

=COUNTIF(C2:C6,">=10")
Result: 2

Number of rows with a quantity of 10 or more.

Results were calculated in real Excel.

Tips for COUNTIF

  • Wildcards work: "Note*" counts values starting with Note.

Related functions

More formula guides

More tools

About COUNTIF Function

Counts the cells that meet a condition, for example how many rows are from Ankara.

Turkish function names were taken directly from Turkish Excel, and the example results on formula pages were calculated in real Excel. Everything runs in your browser; your data is never uploaded.

How to use COUNTIF Function

  1. Type the formulaStart typing =COUNTIF( in a cell; Excel shows the arguments.
  2. Fill in the argumentsSeparate them with commas (semicolons in Turkish Excel).
  3. Press EnterCheck the result; you can also try it in the tester below.

Frequently asked questions

What is COUNTIF in Turkish Excel?

In Turkish Excel, COUNTIF is called EĞERSAY. Turkish Excel also separates arguments with semicolons (;) instead of commas.

Which Excel versions have COUNTIF?

COUNTIF is available in all current Excel versions (2010 and later, Microsoft 365).