ARRAYFORMULA Function in Google Sheets

Apply a formula to a range of cells using the ARRAYFORMULA function.

ARRAYFORMULA Function

The ARRAYFORMULA function in Google Sheets allows you to apply a formula to a range of cells, enabling you to perform operations on multiple values at once.

Syntax

ARRAYFORMULA(array_formula)
  • array_formula: The formula you want to apply to a range of cells. This is a required parameter.

Examples

  1. Basic Usage

Apply a formula to a range of cells:

=ARRAYFORMULA(A1:A10 * B1:B10)

This will multiply each value in column A by the corresponding value in column B.

  1. Using with Functions

Apply a function across a range:

=ARRAYFORMULA(TEXT(A1:A10, "yyyy-mm-dd"))

This will convert dates in column A to the specified format.

Notes

  • ARRAYFORMULA can simplify complex calculations that involve multiple cells.
  • It is essential for working with arrays and ranges dynamically.
  • SUMPRODUCT: Multiply corresponding items in arrays and return the sum.
  • FILTER: Filter a range of data based on criteria.