Skip to Content

BYCOL

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

Syntax

BYCOL(array, lambda)

Parameters

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

Example

=BYCOL(A1:C3, LAMBDA(col, SUM(col)))
Returns: ArraySince: Microsoft 365