SheetFX
≡
<< Go back to all functions

ARRAYFORMULA

The ARRAYFORMULA function in Google Sheets enables the display of values returned from an array formula into multiple rows and/or columns and the use of non-array functions with arrays.

Function Syntax and Parameters

Syntax: ARRAYFORMULA(array_formula)

Parameters:

  • array_formula: The formula or range to apply to the array.

Step-by-Step Tutorial

  1. Using ARRAYFORMULA to apply a formula to an array:
    • Example: If you want to apply the SUM function to a range A1:A3 and display the result in cells B1:B3, enter =ARRAYFORMULA(SUM(A1:A3)) in cell B1 and press Enter.

Use Cases and Scenarios

  1. Expanding Formulas: Automatically apply a formula to a range of cells without having to copy and paste it manually.
  2. Conditional Formatting: Apply formatting rules to multiple cells based on a formula.
  3. Dynamic Data Manipulation: Perform operations and calculations on arrays of data.

Related Functions

  • SUM: Calculate the sum of a range of cells.
  • AVERAGE: Calculate the average value of a range of cells.

Related Articles