Applies a LAMBDA function to each row in an array and returns an array of results.
この関数は Google スプレッドシートでも Excel と同じように機能します。構文も引数も同じです。
BYROW(array, lambda)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 sums
Calculates the sum of each row in the range A1:B2.
No, BYROW always returns an array of results, one for each row in the input array.