What is SUMIF called in Spanish?

In Spanish Excel it is SUMAR.SI. The formula =SUMIF($A$2:$A$10,D2,$B$2:$B$10) is written =SUMAR.SI($A$2:$A$10;D2;$B$2:$B$10) (or with commas in Mexico).

Why does SUMIF use semicolons in some Excel versions?

It depends on regional settings. Where the comma is the decimal mark (Spain, much of South America), Excel separates arguments with semicolons. English Excel and Mexican Spanish Excel use commas.

Excel SUMIF function

Adds only the rows that meet a condition. In Spanish Excel it is called SUMAR.SI.

Syntax

English Excel

=SUMIF(range, criteria, [sum_range])

Spanish Excel (Mexico)

=SUMAR.SI(rango, criterio, [rango_suma])

Spanish Excel (Spain, Latin America)

=SUMAR.SI(rango; criterio; [rango_suma])

Argument	What it is
range	The cells checked against the condition.
criteria	The condition.
sum_rangeoptional	The cells to add; if omitted, the range itself is added.

Example

SUMIF(range, criteria, sum_range) adds only the rows that meet the criterion. The criterion can be a cell, so one formula works for several categories.

=SUMIF($A$2:$A$10,D2,$B$2:$B$10)

Common mistake

If you copy the formula, anchor the ranges with $ so they do not shift.

About Ads

This site uses Google AdSense to display ads. These ads help us keep WebHerramientas completely free. Ads are managed by Google and meet strict security and privacy standards.

Practice SUMIF

Type the formula in the sheet and check it instantly. Spanish or English function names both work. See all lessons

Your progress0/94

My Excel is inExcel functions in English and Spanish

SUMIF

SUMIF(range, criteria, sum_range) adds only the rows that meet the criterion. The criterion can be a cell, so one formula works for several categories.

Example=SUMIF($A$2:$A$10,D2,$B$2:$B$10)SUMAR.SI = SUMIF

In E2, add up the sales for the region in D2. It will be copied to E3 and E4 for the other regions.

	A	B	D	E
1	Region	Sale	Region	Total
2	South	800	North
3	Central	2,300	South
4	North	1,200	Central
5	South	640
6	North	450
7	Central	900
8	North	1,750
9	South	310
10	Central	1,180
11

Tip: while typing, click a cell or drag across several to insert their reference.

Frequently asked questions

What is SUMIF called in Spanish?: In Spanish Excel it is SUMAR.SI. The formula =SUMIF($A$2:$A$10,D2,$B$2:$B$10) is written =SUMAR.SI($A$2:$A$10;D2;$B$2:$B$10) (or with commas in Mexico).
Why does SUMIF use semicolons in some Excel versions?: It depends on regional settings. Where the comma is the decimal mark (Spain, much of South America), Excel separates arguments with semicolons. English Excel and Mexican Spanish Excel use commas.
What is the most common SUMIF mistake?: If you copy the formula, anchor the ranges with $ so they do not shift.