Excel COUNTIFS Function: How to Use It, with Examples
Turkish: ÇOKEĞERSAY

Counts the rows that meet all of several conditions.

COUNTIFS syntax

=COUNTIFS(criteria_range1, criteria1, …)

In Turkish Excel: =ÇOKEĞERSAY(ölçüt_aralığı1; ölçüt1; …)

ArgumentDescription
criteria_range1The range for the first condition.
criteria1The first condition.
…More range/criteria pairs.

COUNTIFS examples

Sample table:

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

Rows in Ankara with a quantity greater than 10.

Results were calculated in real Excel.

Tips for COUNTIFS

  • All ranges must be the same size.

Related functions

More formula guides

More tools

About COUNTIFS Function

Counts the rows that meet all of several conditions.

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 COUNTIFS Function

  1. Type the formulaStart typing =COUNTIFS( 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 COUNTIFS in Turkish Excel?

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

Which Excel versions have COUNTIFS?

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