What is COUNT called in Spanish?

In Spanish Google Sheets it is CONTAR. The formula =COUNT(B2:B9) is written =CONTAR(B2:B9) (or with commas under a Mexico locale).

Why does COUNT 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 COUNT function

Counts how many cells contain numbers. In Spanish Sheets it is called CONTAR.

Syntax

English Sheets

=COUNT(value1, [value2], …)

Spanish Sheets (Mexico locale)

=CONTAR(valor1, [valor2], …)

Spanish Sheets (Spain, Latin America)

=CONTAR(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.

=COUNT(B2:B9)

Common mistake

It does not count text; to count every non-empty cell use COUNTA.

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 COUNT

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 COUNT called in Spanish?: In Spanish Google Sheets it is CONTAR. The formula =COUNT(B2:B9) is written =CONTAR(B2:B9) (or with commas under a Mexico locale).
Why does COUNT 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 COUNT mistake?: It does not count text; to count every non-empty cell use COUNTA.