BYROW

BYROW(array, function)

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

array	An array to be separated by row.
function	The LAMBDA function: lambda(row) or Eta Reduced Lambda.

REMARKS

* This function was added in Excel 2024.
* 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.
* The "row" is the row from array.
* You can use the AVERAGE function to return the arithmetic mean of the numerical values.
* You can use the BYCOL function to return the results from applying a LAMBDA function to each column in an array.
* You can use the MAX function to return the largest numerical value.
* You can use the SUM function to return the total of the numerical values.
* This function was first released in July 2021.
* If you are using Excel 2024 you cannot use the Eta Reduced Lambda syntax.
* For the Microsoft documentation refer to support.microsoft.com

	A	B	C	D
1	=BYROW(B1:D1, SUM) = 12	2	4	6
2	=BYROW(5, LAMBDA(p_one, SUM(p_one, p_one))) = 10
3	=BYROW(10, LAMBDA(p_one, SUM(p_one, p_one))) = 20
4	=BYROW({10, 20}, LAMBDA(p_one, SUM(p_one))) = 30
5	=BYROW({10, 20, 30, 40}, LAMBDA(p_one, MAX(p_one))) = 40
6	=BYROW(B1:D1, LAMBDA(p_one, SUM(p_one))) = 12
7	=BYROW(B1:D1, LAMBDA(p_one, AVERAGE(p_one))) = 4
8	=BYROW({10;20},LAMBDA(p_one, SUM(p_one))) = {10; 20}
9	=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.