COUNT in English and Spanish
| English Excel | Spanish Excel | |
|---|---|---|
| Function name | COUNT | CONTAR |
| Syntax | =COUNT(value1, [value2], ...) | =CONTAR(value1; [value2]; ...) |
| Example | =COUNT(A1:A20) | =CONTAR(A1:A20) |
Argument names are shown in English for reference. Spanish examples use the semicolon setting.
What COUNT does
Counts the cells that contain numbers. Example: Counts the cells in A1:A20 that contain numbers.
Semicolons, commas and decimals
Spanish versions of Excel separate arguments with a semicolon or a comma depending on the regional settings of the computer. With semicolons, decimals are written with a comma (3,14). With commas, decimals use a point (3.14). FormulaCheck converts both.
A common mistake
COUNT skips text. Use COUNTA to count any non-empty cell.
Have a formula to translate or check?
Open FormulaCheckQuestions
Why does my Spanish Excel use semicolons?
Spanish versions of Excel separate arguments with a semicolon or a comma depending on the regional settings of the computer. With semicolons, decimals are written with a comma (3,14). With commas, decimals use a point (3.14). FormulaCheck converts both.
What is a common mistake with COUNT?
COUNT skips text. Use COUNTA to count any non-empty cell.