Home › Functions › Statistical › COUNTIFS
fx
COUNTIFS
Statistical  ·  Since: Excel 2007  ·  9 languages

The COUNTIFS function applies criteria to cells across multiple ranges and counts the number of times all criteria are met.

🌐 Translations

English COUNTIFS
Deutsch ZÄHLENWENNS
Français NB.SI.ENS
Español CONTAR.SI.CONJUNTO
Italiano CONTA.PIÙ.SE
Português CONT.SES
Nederlands AANTALLEN.ALS
Polski LICZ.WARUNKI
Русский СЧЁТЕСЛИМН

📦 Availability

Excel versionAvailable
Excel 2007 ✓
Excel 2013 ✓
Excel 2019 ✓
Excel 2021 ✓
Microsoft 365 ✓
Translate a formula with this function
fx EN
fx DE

⌨ Syntax

COUNTIFS(criteria_range1,criteria1,[criteria_range2,criteria2]…)

Arguments

criteria_range1 (required) — The first range in which to evaluate the associated criteria.
criteria1 (required) — The criteria in the form of a number, expression, cell reference, or text that define which cells will be counted. For example, criteria can be expressed as 32, ">32", B4, "apples", or "32".

▶ Examples

=COUNTIFS(B2:D2,"=Yes")
=COUNTIFS(A2:A7,"<6",A2:A7,">1")
=COUNTIFS(B2:B5,"=Yes",C2:C5,"=Yes")

Related functions

Copied to clipboard