What is SUMPRODUCT called in Spanish?

In Spanish Excel it is SUMAPRODUCTO. The formula =SUMPRODUCT(B2:B6,C2:C6) is written =SUMAPRODUCTO(B2:B6;C2:C6) (or with commas in Mexico).

Why does SUMPRODUCT 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 SUMPRODUCT function

Multiplies ranges row by row and adds up the results: the total of quantity × price in one formula. In Spanish Excel it is called SUMAPRODUCTO.

Syntax

English Excel

=SUMPRODUCT(array1, [array2], …)

Spanish Excel (Mexico)

=SUMAPRODUCTO(matriz1, [matriz2], …)

Spanish Excel (Spain, Latin America)

=SUMAPRODUCTO(matriz1; [matriz2]; …)

Argument	What it is
array1	The first range.
array2optional	More ranges of the same size.

Example

SUMPRODUCT multiplies the ranges row by row and adds up the results. It gives the total of a shopping list without a helper column.

=SUMPRODUCT(B2:B6,C2:C6)

Common mistake

It also takes conditions: SUMPRODUCT((A2:A10="North")*B2:B10) adds only North, even in old Excel versions.

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 SUMPRODUCT

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

SUMPRODUCT

SUMPRODUCT multiplies the ranges row by row and adds up the results. It gives the total of a shopping list without a helper column.

Example=SUMPRODUCT(B2:B6,C2:C6)SUMAPRODUCTO = SUMPRODUCT

In F2, calculate the shopping total (quantity times price for each item, all added up) in a single formula.

	A	B	C	E
1	Item	Quantity	Price
2	Milk	6	28	Shopping total
3	Eggs (dozen)	2	52
4	Bread	3	45
5	Apples (kg)	1.5	48
6	Coffee	1	189
7

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

Frequently asked questions

What is SUMPRODUCT called in Spanish?: In Spanish Excel it is SUMAPRODUCTO. The formula =SUMPRODUCT(B2:B6,C2:C6) is written =SUMAPRODUCTO(B2:B6;C2:C6) (or with commas in Mexico).
Why does SUMPRODUCT 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 SUMPRODUCT mistake?: It also takes conditions: SUMPRODUCT((A2:A10="North")*B2:B10) adds only North, even in old Excel versions.