BYCOL Function. Split a cell range by columns and tally by column.(Microsoft Excel)

Japanese version.

The BYCOL function is a new function added to Excel in February 2022.

It is a helper function to the LAMBDA function.
It divides a cell range by columns and spills the results by column.

How it works

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


In the following example, if a formula is set in cell B8, the Spill will automatically extend the formula to cells C8 and D8.

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