Excel like a finance pro.
← The libraryPractice · 3 questions →
Logical function
BYCOL
Applies a LAMBDA to each column of an array and returns one result per column.
OccasionalDifficulty 1700 · ExpertUsage rank #104 of 520
When to use it
Applies a LAMBDA to each column of an array and returns one value per column.
The shape of it
- Syntax
=BYCOL(array, lambda)
Worked examples
Column sums
=BYCOL({1,2;3,4},LAMBDA(c,SUM(c))) → {4,6}
Column sums.
Column averages
=BYCOL(B2:D6,LAMBDA(c,AVERAGE(c))) → an average per column
Column averages in one row.
Column max
=BYCOL(B2:D6,LAMBDA(c,MAX(c))) → a max per column
Column maximums.
Worth knowing
- A totals row for a dynamic array without knowing its width.
- BYROW for rows.
- Pair with HSTACK to append the result.
Where it goes wrong
- The LAMBDA must return one value per column.
- Requires Microsoft 365.
Related
Learn the moves here — or let Wauvel run them on your numbers.
Meet your AI CFO →One CFO-grade Excel tip a week
A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.