What is COUNTA called in Spanish?

In Spanish Google Sheets it is CONTARA. The formula =COUNTA(A2:A9) is written =CONTARA(A2:A9) (or with commas under a Mexico locale).

Why does COUNTA use semicolons in some spreadsheets?

It depends on each spreadsheet's locale, under File > Settings. Where the comma is the decimal mark (Spain, much of South America), arguments are separated by semicolons. Mexico and United States locales use commas.

Google Sheets COUNTA function

Counts the cells that are not empty, whether they hold numbers or text. In Spanish Sheets it is called CONTARA.

Syntax

English Sheets

=COUNTA(value1, [value2], …)

Spanish Sheets (Mexico locale)

=CONTARA(valor1, [valor2], …)

Spanish Sheets (Spain, Latin America)

=CONTARA(valor1; [valor2]; …)

Argument	What it is
value1	The first value or range.
value2optional	More values or ranges.

Example

COUNT counts only cells that hold numbers. COUNTA counts every cell that is not blank, whether it holds numbers or text.

=COUNTA(A2:A9)

Common mistake

A formula returning "" counts as non-empty even though the cell looks blank.

About Ads

This site uses Google AdSense to display ads. These ads help us keep WebHerramientas completely free. Ads are managed by Google and meet strict security and privacy standards.

Practice COUNTA

Type the formula in the sheet and check it instantly. Spanish or English function names both work. See all lessons

COUNT and COUNTA

COUNT counts only cells that hold numbers. COUNTA counts every cell that is not blank, whether it holds numbers or text.

Example=COUNT(B2:B9)CONTAR = COUNT CONTARA = COUNTA

Step 1/2

In E2, count how many employees have overtime logged as a number (a 0 counts too).

	A	B	D
1	Employee	Overtime hours
2	Marisol	4	With hours logged
3	Fernando	Pending	Total employees
4	Gabriela	7
5	Hugo
6	Daniela	2
7	Óscar	0
8	Natalia	Pending
9	Raúl	5
10

Tip: while typing, click a cell or drag across several to insert their reference.

Frequently asked questions

What is COUNTA called in Spanish?: In Spanish Google Sheets it is CONTARA. The formula =COUNTA(A2:A9) is written =CONTARA(A2:A9) (or with commas under a Mexico locale).
Why does COUNTA use semicolons in some spreadsheets?: It depends on each spreadsheet's locale, under File > Settings. Where the comma is the decimal mark (Spain, much of South America), arguments are separated by semicolons. Mexico and United States locales use commas.
What is the most common COUNTA mistake?: A formula returning "" counts as non-empty even though the cell looks blank.