BYROW

Formulas / BYROW
Apply a function to each row in an array.
==BYROW(array, [lambda])
  • array - The first argument
  • lambda - The second argument

Examples

  • =BYROW(data,LAMBDA(row,SUM(row)))

    This example returns an array with 11 sums, and allows you to quickly calculate the sum of each row in a set of data.

  • =BYROW(data,LAMBDA(row,MAX(row)))

    This example returns the maximum value in each row.

  • =BYROW(data,LAMBDA(row,MIN(row)))

    This example returns the minimum value in each row.

  • =BYROW(data,LAMBDA(row,AVERAGE(row)))

    This example returns an average for each row.


Summary

The BYROW function applies a lambda to each row in an array and returns an array of the results. It requires two arguments, an array and a lambda, and will throw errors if either of these are invalid or incorrect.

  • The BYROW function requires two arguments, an array and a lambda.
  • The BYROW function will return one result per row in a single array.

Frequently Asked Questions

What is the BYROW function?
The BYROW function is a LAMBDA function that can be applied to each row of a array. It returns one result per row in a single array.
What are the arguments of the BYROW function?
The arguments for the BYROW function are array and lambda. The array argument is the array or range to process and the lambda argument is the LAMBDA function that is applied to each row in a data set.
What results does the BYROW function provide?
The BYROW function returns one result per row in a single array.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV