Skip to Content

BYROW

Applies a LAMBDA to each row and returns an array of the results

Syntax

BYROW(array, lambda)

Parameters

  • array: Required. An array to be separated by row
  • lambda: Required. A LAMBDA that takes a row as a single parameter and calculates one result

Example

=BYROW(A1:C3, LAMBDA(row, SUM(row)))
Returns: ArraySince: Microsoft 365