SUMIFS in English and Spanish
| English Excel | Spanish Excel | |
|---|---|---|
| Function name | SUMIFS | SUMAR.SI.CONJUNTO |
| Syntax | =SUMIFS(sum_range, criteria_range1, criteria1, ...) | =SUMAR.SI.CONJUNTO(sum_range; criteria_range1; criteria1; ...) |
| Example | =SUMIFS(C1:C20,A1:A20,"Paid",B1:B20,">100") | =SUMAR.SI.CONJUNTO(C1:C20;A1:A20;"Paid";B1:B20;">100") |
Argument names are shown in English for reference. Spanish examples use the semicolon setting.
What SUMIFS does
Adds the values that meet several conditions. Example: Adds column C where A is Paid and B is above 100.
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
The sum range is the first argument, the reverse of SUMIF.
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 SUMIFS?
The sum range is the first argument, the reverse of SUMIF.