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).
Type it in a live spreadsheet, get instant feedback. No videos, no downloads.
Start practising free →