BYROW Function. Split a cell range by rows and tally by row.(Microsoft Excel)


The BYROW function is a new function added in February 2022.

It is a helper function for the LAMBDA function that divides the cell range of the function argument by rows and spill the results row by row.

How it works

=BYROW(Array, Lambda Function)
ArrayRequired argument.
The cell range to be aggregated.
This cell range is divided by rows.
Lambda FunctionRequired argument.
Specify the formula to be performed per line.


In the following example, if a formula is set in cell E5, the spill will automatically extend the formula to cells E6 and E7.

=BYROW( B5:D7, LAMBDA(totalRange, SUM( totalRange + totalRange * A2))))


Examples of Use

Formulas to extract only rows with values.



Examples of Use.

Calculating the median in a Pivot table. Its alternative method.