Applies a LAMBDA function to each row in an array and returns an array of results.
Cú pháp
BYROW(array, lambda)Đối số
arraybắt buộc
The array or range to be processed.
lambdabắt buộc
A LAMBDA function that takes a single row as an argument and performs a calculation.
The BYROW function processes an array row by row using a custom LAMBDA function. It is particularly useful for performing row-wise calculations, such as summing or averaging data across specific rows in a range.
=BYROW(A1:B2, LAMBDA(row, SUM(row)))→Array of row sumsCalculates the sum of each row in the range A1:B2.
Define the range
Select the array or range of cells you want to process row by row.
Write the LAMBDA
Create a LAMBDA function that defines the operation to perform on each row variable.
No, BYROW always returns an array of results, one for each row in the input array.