Home › COUNTA

COUNTA in every language

StatisticalLegacyLast verified 2026-11-04

LanguageNameSyntaxLibreOfficeSheets
EnglishCOUNTACOUNTA(value1, [value2])——
GermanANZAHL2ANZAHL2(Wert1; [Wert2])ANZAHL2ANZAHL2
FrenchNBVALNBVAL(valeur1; [valeur2])NBVALNBVAL
SpanishCONTARACONTARA(valor1; [valor2])CONTARACONTARA
Portuguese (Brazil)CONT.VALORESCONT.VALORES(valor1; [valor2])CONT.VALORESCONT.VALORES
DutchAANTALARGAANTALARG(waarde1; [waarde2])AANTALARGAANTALARG
ItalianCONTA.VALORICONTA.VALORI(val1; [val2])CONTA.VALORICONTA.VALORI

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 COUNTA