BYROW
Applies a LAMBDA to each row and returns an array of the results.
LogicalDynamic Arrays & LAMBDALogic & ConditionsModern Excel Functions
What it does
Applies a custom LAMBDA calculation to each row in an array and returns the results as a single column.
Syntax
BYROW(array, lambda)
Arguments
array(array) — The array to process.lambda(function) — A LAMBDA function that takes a row as input and returns a single result.
Examples
Sum each row
Calculate the sum of each row.
FORMULA
=BYROW(A1:B3, LAMBDA(row, SUM(row)))
RESULT
[30; 70; 110]
SAMPLE DATA
| A | B | |
|---|---|---|
| 1 | Val1 | Val2 |
| 2 | 10 | 20 |
| 3 | 30 | 40 |
| 4 | 50 | 60 |