Excel functions / Logical

BYROW function

Runs a function on each row of an array and returns one result per row.

Syntax

=BYROW(array, lambda)

Arguments

When to use it

BYROW runs a LAMBDA on each row of a range and spills one result per row: the total, the largest, or any calculation of the row. It replaces a helper formula filled down beside a table.

Examples

  1. The total of each row

    ABCDE
    1Q1Q2Q3
    210203060
    3405060150

    In E2: =BYROW(A2:C3, LAMBDA(row, SUM(row))) → 60; 150

    Try this example

  2. The same with a function by name

    ABCDE
    1Q1Q2Q3
    210203030
    340506060

    In E2: =BYROW(A2:C3, MAX) → 30; 60

    Try this example

Common mistakes

Try BYROW in the playground

Practise it

Related functions