ARRAYFORMULA

  • Updated

Enables the use of non-array functions with arrays.

NOTE: spillover capabilities whereby values returned from an array formula spill over into multiple rows and/or columns is not yet supported. This is a forthcoming feature.

Sample Usage

ARRAYFORMULA(SUM(IF(A1:A10>5, A1:A10, 0)))

This example sums those values (in cells A1:A10) that are greater than 5.

ARRAYFORMULA(A1:C1+A2:C2)

Syntax

ARRAYFORMULA(array_formula)

  • array_formula - Uses an array (a mathematical expression referring to a range of cells) or a function that returns a result.

Notes

  • Note that array formulas cannot be exported.