COUNTIFS in English and Spanish
| English Excel | Spanish Excel | |
|---|---|---|
| Function name | COUNTIFS | CONTAR.SI.CONJUNTO |
| Syntax | =COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2], ...) | =CONTAR.SI.CONJUNTO(criteria_range1; criteria1; [criteria_range2; criteria2]; ...) |
| Example | =COUNTIFS(A1:A20,">10",B1:B20,"Yes") | =CONTAR.SI.CONJUNTO(A1:A20;">10";B1:B20;"Yes") |
Argument names are shown in English for reference. Spanish examples use the semicolon setting.
What COUNTIFS does
Counts the rows that meet several conditions at once. Example: Counts rows where column A is above 10 and column B says Yes.
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
Every criteria range must have the same size.
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 COUNTIFS?
Every criteria range must have the same size.