SUMIFS in Excel & Google Sheets
Adds the cells that meet one or more conditions. Perfect for totals by category, month or person.
Syntax
=SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2…]) Example: Total spent on groceries
=SUMIFS(C2:C6, B2:B6, "Groceries") =SUMAR.SI.CONJUNTO(C2:C6; B2:B6; "Groceries") Adds the amounts in column C where the category in column B is "Groceries".
SUMIFS in Spanish
In Spanish Excel and Google Sheets, SUMIFS is called SUMAR.SI.CONJUNTO. It's the same function: files translate automatically when opened in another language. When you type it by hand, the name and the argument separator change.
| English | Spanish | |
|---|---|---|
| Function | SUMIFS | SUMAR.SI.CONJUNTO |
| Separator | , | ; |
| Example | =SUMIFS(C2:C6, B2:B6, "Groceries") | =SUMAR.SI.CONJUNTO(C2:C6; B2:B6; "Groceries") |
The separator depends on regional settings: Spanish versions usually use semicolons, but countries with a decimal point (like Mexico) may use commas.
Translate another formulaArguments
SUMIFS FAQ
What is SUMIFS in Spanish?
In Spanish, SUMIFS is SUMAR.SI.CONJUNTO. When you type it by hand in a Spanish Excel, arguments are usually separated by semicolons (;): =SUMAR.SI.CONJUNTO(C2:C6; B2:B6; "Groceries")
Does SUMIFS work in Google Sheets?
Yes. SUMIFS works in Google Sheets with the same syntax as in Excel. In a sheet set to Spanish it's called SUMAR.SI.CONJUNTO. The separator (comma or semicolon) follows the sheet's locale, under File → Settings.
What is the difference between SUMIF and SUMIFS?
SUMIF takes a single condition and the sum range goes last. SUMIFS takes several conditions and the sum range goes first. SUMIFS can do everything SUMIF does.
How do I sum between two dates with SUMIFS?
Use the date column twice: =SUMIFS(C2:C100, A2:A100, ">="&F1, A2:A100, "<="&F2), where F1 and F2 hold the start and end dates.