COUNTIF in English and Spanish
| English Excel | Spanish Excel | |
|---|---|---|
| Function name | COUNTIF | CONTAR.SI |
| Syntax | =COUNTIF(range, criteria) | =CONTAR.SI(range; criteria) |
| Example | =COUNTIF(A1:A20,">10") | =CONTAR.SI(A1:A20;">10") |
Argument names are shown in English for reference. Spanish examples use the semicolon setting.
What COUNTIF does
Counts the cells that meet one condition. Example: Counts how many cells in A1:A20 are greater than 10.
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
Comparison operators must be inside quotes, like ">10". Without quotes the formula is invalid.
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 COUNTIF?
Comparison operators must be inside quotes, like ">10". Without quotes the formula is invalid.