# BYROW

BYROW(array, lambda(row))

Returns the results from applying a LAMBDA function to each row in an array.

 array An array to be separated by row. lambda A nested LAMBDA function that takes a single parameter. row A row from array.

 REMARKS
 * This function was added in Microsoft 365.* This function can create a Dynamic Array Formula.* This function uses the LAMBDA function.* This LAMBDA function must take a single parameter.* This LAMBDA function must have parameter names that do not contain any numbers.* This LAMBDA function must have a calculation formula that is compatible with arrays.* You can use the BYCOL function to return the results from applying a LAMBDA function to each column in an array.* This function was released in July 2021.* For the Microsoft documentation refer to support.microsoft.com* For the Google documentation refer to support.google.com

 A B C D 1 =BYROW(5,LAMBDA(p_one,SUM(p_one,p_one))) = 10 100 200 300 2 =BYROW(10,LAMBDA(p_one,SUM(p_one,p_one))) = 20 3 =BYROW({10,20},LAMBDA(p_one,SUM(p_one))) = 30 4 =BYROW({10,20,30,40},LAMBDA(p_one,MAX(p_one))) = 40 5 =BYROW(B1:D1,LAMBDA(p_one,SUM(p_one))) = 600 6 =BYROW(B1:D1,LAMBDA(p_one,AVERAGE(p_one))) = 200 7 =BYROW({10;20},LAMBDA(p_one,SUM(p_one))) = {10; 20} 8 =BYROW(B1:D1,LAMBDA(p_one,2*p_one)) = #CALC!

 1 - What is the result of passing in the value "5" to the function "SUM(5,5)".2 - What is the result of passing in the value "10" to the function "SUM(10,10)".3 - What is the result of passing in the array values {10,20} (with commas) to the function "SUM(array)".4 - What is the result of passing in the array values {10,20,30,40} (with commas) to the function "MAX(array)".5 - What is the result of passing in the values from cell reference "B1:B3" to the functon "SUM(array)".6 - What is the result of passing in the values from cell reference "B1:B3" to the functon "AVERAGE(array)".7 - What is the result of passing in the array values {10;20} (with semi-colons) to the function "SUM(array)".8 - If the argument passed to the LAMBDA function is not an array, then #CALC! is returned.