What is SUM called in Spanish?

In Spanish Google Sheets it is SUMA. The formula =SUM(B2:B7) is written =SUMA(B2:B7) (or with commas under a Mexico locale).

Why does SUM use semicolons in some spreadsheets?

It depends on each spreadsheet's locale, under File > Settings. Where the comma is the decimal mark (Spain, much of South America), arguments are separated by semicolons. Mexico and United States locales use commas.

Google Sheets SUM function

Adds numbers, cells and ranges. It is the most used function in Sheets. In Spanish Sheets it is called SUMA.

Syntax

English Sheets

=SUM(value1, [value2], …)

Spanish Sheets (Mexico locale)

=SUMA(valor1, [valor2], …)

Spanish Sheets (Spain, Latin America)

=SUMA(valor1; [valor2]; …)

Argument	What it is
value1	The first number, cell or range to add.
value2optional	More numbers or ranges.

Example

SUM adds up a range: B2:B7 means "from B2 to B7". Between arguments, Sheets uses "," or ";" depending on the spreadsheet’s locale (File > Settings), not your computer’s: the United States or Mexico use ",", Spain or Argentina use ";".

=SUM(B2:B7)

Common mistake

Numbers pasted as text (left-aligned) are not added. Convert them with Format > Number first.

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 SUM

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

SUM

Example=SUM(B2:B7)SUMA = SUM

In B8, calculate the month’s total spending with SUM.

	A	B
1	Expense	Amount
2	Rent	8500
3	Electricity	650
4	Internet	499
5	Groceries	3200
6	Transport	1200
7	Phone	349
8	Total
9

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

Frequently asked questions

What is SUM called in Spanish?: In Spanish Google Sheets it is SUMA. The formula =SUM(B2:B7) is written =SUMA(B2:B7) (or with commas under a Mexico locale).
Why does SUM use semicolons in some spreadsheets?: It depends on each spreadsheet's locale, under File > Settings. Where the comma is the decimal mark (Spain, much of South America), arguments are separated by semicolons. Mexico and United States locales use commas.
What is the most common SUM mistake?: Numbers pasted as text (left-aligned) are not added. Convert them with Format > Number first.