Home › COUNTIF

COUNTIF in every language

StatisticalLegacyLast verified 2026-11-04

LanguageNameSyntaxLibreOfficeSheets
EnglishCOUNTIFCOUNTIF(range, criteria)——
GermanZÄHLENWENNZÄHLENWENN(Bereich; Suchkriterium)ZÄHLENWENNZÄHLENWENN
FrenchNB.SINB.SI(plage; critères)NB.SINB.SI
SpanishCONTAR.SICONTAR.SI(rango; criterios)CONTAR.SICONTAR.SI
Portuguese (Brazil)CONT.SECONT.SE(intervalo; critério)CONT.SECONT.SE
DutchAANTAL.ALSAANTAL.ALS(bereik; criterium)AANTAL.ALSAANTAL.ALS
ItalianCONTA.SECONTA.SE(intervallo; criteri)CONTA.SECONTA.SE

Names and arguments from Microsoft Support; the LibreOffice and Google Sheets columns are those products' own localized names. Array-constant separators and localized error values are not yet covered.

Translate a formula with COUNTIF