REDUCE

REDUCE(initial_value, array, function)

Returns the total value after reducing an array by applying a LAMBDA function.

initial_value	Sets the starting value for the accumulator.
array	An array to be reduced.
lambda	The LAMBDA function: lambda(accumulator, value, body)

REMARKS

* This function was added in Excel 2024.
* This function uses the LAMBDA function.
* This LAMBDA function must take two parameters.
* This LAMBDA function must have parameter names that do not include numbers.
* The Eta Reduced Lambda syntax cannot be used here because there are multiple arguments that need to be passed.
* If the array is text, set "initial_value" to "".
* The "accumulator" value totalled up and returned as the final result.
* The "value" calculation applied to each element in the array.
* The "body" value ?
* You can use the MAP function to return an identical array by applying a LAMBDA function to do some processing.
* You can use the SCAN function to return an identical array by applying a LAMBDA function to return some intermediate calculation values.
* This function was first released in July 2021.
* For the Microsoft documentation refer to support.microsoft.com

	A	B	C	D
1	=REDUCE(1, B1:D2, LAMBDA(p_one, p_two, p_one+p_two)) = 22	1	2	3
2	=REDUCE(10, B1:D2, LAMBDA(p_one, p_two, p_one+p_two)) = 31	4	5	6
3	=REDUCE(1, B1:D2, LAMBDA(p_one, p_two, p_one*p_two)) = 720

1 - We would like to display the total of all the numbers, with an initial value of 1.
2 - We would like to display the total of all the numbers, with an initial value of 10.
3 - We would like to display the total value after multiplying all the numbers together.