Logical Excel 365 ◉ 43 views Dynamic Array

=BYCOL()

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

Applies To: Excel for Microsoft 365Excel for Microsoft 365 for MacExcel 2024Excel 2024 for Mac

=BYCOL (array, lambda(column))

Hover argument names in the table for details.

Output typeArray

Popularity30 / 100

VolatileNo

Dynamic ArrayYes

Download sample .xlsx ▦ Try in Playground Dedicated file for this function — safe & lightweight · sample data + live formulas

⬇ Download Sample Workbook

A dedicated .xlsx for =BYCOL() with Persian sample data & live formulas — open in Excel and practice.

Download BYCOL.xlsx ~ 8–12 KB · No macros

%d questions — syntax, example & errors — test yourself!

Start quiz →

Argument	Type	Required	Description
`array`	Array	Optional	An array to be separated by column.
`lambda`	Any type	Optional	A LAMBDA that takes a column as a single parameter and calculates one result. The LAMBDA takes a single parameter:
`column`	Range	Optional	A column from array.

Example 1 =BYCOL(B2:E10, LAMBDA(c, SUM(c)))

Example 2 =BYCOL(B2:E10, LAMBDA(c, AVERAGE(c)))

#VALUE! Providing an invalid LAMBDA function or an incorrect number of parameters returns a #VALUE! error called "Incorrect Parameters".

Fix: ساختار LAMBDA را بررسی کنید که دقیقاً یک پارامتر (ستون) بگیرد.

#CALC! Not providing a LAMBDA function or anything but a single value returned from the LAMBDA function returns a #CALC error.