SheetFX
≡
<< Go back to all functions

BYROW

The BYROW function in Google Sheets is a useful tool for grouping an array by rows by applying a LAMBDA function to each row. This function allows for efficient data manipulation and analysis. Learn how to use BYROW effectively with our comprehensive guide below.

Function Syntax and Parameters

Syntax: BYROW(array_or_range, LAMBDA)

Parameters:

  • array_or_range: The array or range of cells to group by rows.
  • LAMBDA: The function to apply to each row.

Step-by-Step Tutorial

  1. Using BYROW to group an array by rows using a LAMBDA function:
    • Example: =BYROW(A1:C3, LAMBDA(row, SUM(row)))
    • Result: Returns an array with the sum of each row in the range A1:C3.

Use Cases and Scenarios

  1. Data Aggregation: Calculate row-wise totals or averages.
  2. Conditional Analysis: Apply custom logic to each row based on specific criteria.
  3. Data Transformation: Convert data in each row according to a defined function.

Related Functions

  • TRANSPOSE: Transpose rows and columns in a range or array.
  • FILTER: Filter rows in an array based on specific conditions.

Related Articles