Logical Excel 365 ◉ 20 views Dynamic Array

=BYROW()

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

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

=BYROW(array, lambda(row))

Hover argument names in the table for details.

Output typeArray

Popularity35 / 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 =BYROW() with Persian sample data & live formulas — open in Excel and practice.

Download BYROW.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 row.
`lambda`	Any type	Optional	A LAMBDA that takes a row as a single parameter and calculates one result. The LAMBDA takes a single parameter:
`row`	Range	Optional	rowA row from array.

Example 1 =BYROW(B2:E10, LAMBDA(r, SUM(r)))

Example 2 =BYROW(B2:E10, LAMBDA(r, AVERAGE(r)))

#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.