FUNCTION CATALOGUE / LOGICAL / ARRAY
BYROW Excel function
Applies a calculation to each row.
Correct sentence to use
Apply [calculation] to each row in [array].
Modify this query in PlainFormula →Example formula
=BYROW(A2:C10,LAMBDA(r,SUM(r)))
Returns one result per row.
Syntax
BYROW(array, lambda)
Argument signature: array, lambda
Availability note
Available in supported Microsoft 365 / newer Excel versions; verify the exact release and platform.