Apply any formula to every row automatically — one result per row, no dragging, no helper columns.
BYROW applies a LAMBDA function to each row of an array and returns one result per row as a spilled column. It replaces the need to enter the same formula in hundreds of rows manually — one BYROW formula handles the entire range.
BYROW(array, lambda)| Argument | What it means |
|---|---|
| array required | The range to process row by row. |
| lambda required | A LAMBDA function with one parameter (representing each row). Must return a single value. |
=BYROW(B2:D20, LAMBDA(row, SUM(row)))Returns a 19-row column where each cell is the SUM of that row across columns B, C, and D. No dragging the SUM formula down required.
=BYROW(B2:D20, LAMBDA(row, MAX(row)))=BYROW(A2:C20, LAMBDA(row, TEXTJOIN(" ", TRUE, row)))Joins all values in each row into a single text string separated by spaces — useful for building full names or addresses from separate columns.
BYROW processes each row and returns one value per row (a column of results). BYCOL processes each column and returns one value per column (a row of results).
Practice these formulas in the Data Analyst track — 100 exercises covering dynamic arrays, data cleaning, and analysis. Free to start.
Start the Data Analyst track free →