sheets365
All versionsGoogle SheetsIn Spanish: SUMAR.SI

SUMIF in Excel & Google Sheets

Adds the cells that meet a single condition. For two or more conditions, use SUMIFS.

Syntax

=SUMIF(range, criteria, [sum_range])

Example: Total spent on groceries

Excel / Sheets · English
=SUMIF(B2:B6, "Groceries", C2:C6)
Excel / Sheets · Español
=SUMAR.SI(B2:B6; "Groceries"; C2:C6)

Adds the amounts in column C where the category in column B is "Groceries".

SUMIF in Spanish

In Spanish Excel and Google Sheets, SUMIF is called SUMAR.SI. 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.

EnglishSpanish
FunctionSUMIFSUMAR.SI
Separator,;
Example=SUMIF(B2:B6, "Groceries", C2:C6)=SUMAR.SI(B2:B6; "Groceries"; C2:C6)

The separator depends on regional settings: Spanish versions usually use semicolons, but countries with a decimal point (like Mexico) may use commas.

Translate another formula

Arguments

rangeRequiredThe cells to test against the condition.
criteriaRequiredThe condition, e.g. "Rent", ">100" or "*north*".
sum_rangeOptionalThe cells to add up. If omitted, adds the cells in range.

SUMIF FAQ

What is SUMIF in Spanish?

In Spanish, SUMIF is SUMAR.SI. When you type it by hand in a Spanish Excel, arguments are usually separated by semicolons (;): =SUMAR.SI(B2:B6; "Groceries"; C2:C6)

Does SUMIF work in Google Sheets?

Yes. SUMIF works in Google Sheets with the same syntax as in Excel. In a sheet set to Spanish it's called SUMAR.SI. The separator (comma or semicolon) follows the sheet's locale, under File → Settings.

What is the difference between SUMIF and SUMIFS?

SUMIF takes one condition and the sum range goes last. SUMIFS takes several conditions and the sum range goes first.

How do I sum values greater than a number?

Put the operator in quotes: =SUMIF(C2:C100, ">100") adds every amount above 100. To compare with a cell, join it: ">"&F1.