Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
BYROW
BYROW passes each row of a multi-column array to a LAMBDA function as an array argument, collecting the single value returned by LAMBDA for each row into a vertical results array. It is used to compute row-level aggregations — such as row sums, row maximums, or custom per-row scores — without helper columns.
Excel
=BYROW(A2:C5,LAMBDA(row,SUM(row)))Google Sheets
=BYROW(A2:C5,LAMBDA(row,SUM(row)))Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
How it works
- 1Arrange your data in a rectangular range with multiple columns (e.g., A2:C5 with three numeric columns per row).
- 2Enter =BYROW(A2:C5,LAMBDA(row,SUM(row))) to output a column where each cell is the sum of the corresponding row.
- 3Replace SUM with other functions: LAMBDA(row,MAX(row)) returns the row maximum, LAMBDA(row,TEXTJOIN(",",TRUE,row)) joins the row into a string.
Need a version for your data?
Try: “Sum each row across three score columns to get a total score per student”