BYCOL Function. Split a cell range by columns and tally by column.(Microsoft Excel)
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)
The cell range to be aggregated.
This cell range is divided by columns.
|Lambda Function||Required 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 ) ) )