What is ARRAYFORMULA called in Spanish?

It has the same name: ARRAYFORMULA. Functions that started in Google Sheets keep their English name even in a Spanish spreadsheet. What changes is the separator: Spain and much of Latin America separate arguments with semicolons.

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

Lets one formula work on whole ranges and fill an entire column. It is a Sheets-only function. It has the same name in Spanish Sheets.

Syntax

English Sheets

=ARRAYFORMULA(array_formula)

Spanish Sheets (Mexico locale)

=ARRAYFORMULA(fórmula_matriz)

Spanish Sheets (Spain, Latin America)

=ARRAYFORMULA(fórmula_matriz)

Argument	What it is
array_formula	A formula that works on whole ranges, like B2:B*C2:C.

Example

ARRAYFORMULA makes one formula work on whole ranges and fill the entire column, with no copying row by row. In Sheets you can add it by pressing Ctrl+Shift+Enter (Cmd+Shift+Enter on a Mac) while typing.

=ARRAYFORMULA(B2:B6*C2:C6)

Common mistake

With open ranges like B2:B it fills to the bottom of the sheet; use IF(B2:B="","", …) to leave empty rows blank.

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 ARRAYFORMULA

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

Your progress0/59

My spreadsheet is inGoogle Sheets functions in English and Spanish

ARRAYFORMULA

Example=ARRAYFORMULA(B2:B6*C2:C6)ARRAYFORMULA: same name in Spanish

Calculate every total with a single formula in D2: price times quantity for all five rows.

	A	B	C	D
1	Product	Price	Quantity	Total
2	Notebook	35	4
3	Pen	12	10
4	Backpack	450	1
5	Calculator	280	2
6	Marker	18	6
7

The dotted outline shows how far the result should spill.

Frequently asked questions

What is ARRAYFORMULA called in Spanish?: It has the same name: ARRAYFORMULA. Functions that started in Google Sheets keep their English name even in a Spanish spreadsheet. What changes is the separator: Spain and much of Latin America separate arguments with semicolons.
Why does ARRAYFORMULA 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 ARRAYFORMULA mistake?: With open ranges like B2:B it fills to the bottom of the sheet; use IF(B2:B="","", …) to leave empty rows blank.