ExcelFlux

BYCOL function

Applies a LAMBDA to each column and returns an array of the results.

Logical · Excel 2024+

Where can you use it?

Teams building reports and business rules. Adapt the example’s decision rule when you need to test a condition or display different results based on it.

Scenario in the workbook

Return one total per column in a horizontal array.

A worked example from the workbook

RowABC
6PositionValueReading
7123
8258
93813
Record 1
=INDEX(BYCOL($A$7:$C$9,LAMBDA(items,SUM(items))),1,A7)

Expected result6

See the inputs and instructions for all 3 examples

Syntax

BYCOL(array, lambda(column))

Copyable formulas

English Excel · en-US
=INDEX(BYCOL($A$7:$C$9,LAMBDA(items,SUM(items))),1,A7)
Turkish Excel · tr-TR
=İNDİS(BYCOL($A$7:$C$9;LAMBDA(items;TOPLA(items)));1;A7)

Worked examples

Return one total per column in a horizontal array.

Open the English sheet. Inputs begin at A6. F7:F9 show the live results and G7:G9 show the original results for comparison.

Row A B C
6 Position Value Reading
7 1 2 3
8 2 5 8
9 3 8 13
Case Formula Expected result
Record 1 =INDEX(BYCOL($A$7:$C$9,LAMBDA(items,SUM(items))),1,A7) 6
Record 2 =INDEX(BYCOL($A$7:$C$9,LAMBDA(items,SUM(items))),1,A8) 15
Record 3 =INDEX(BYCOL($A$7:$C$9,LAMBDA(items,SUM(items))),1,A9) 24
Microsoft Excel reference