REDUCE

REDUCE(initial_value, array, function)

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

initial_valueSets the starting value for the accumulator.
arrayAn array to be reduced.
lambdaThe 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
* For the Google documentation refer to support.google.com

 ABCDE
1=REDUCE(1, C1:E2, LAMBDA(p_one, p_two, p_one+p_two)) = 22 123
2=REDUCE(10, C1:E2, LAMBDA(p_one, p_two, p_one+p_two)) = 31 456
3=REDUCE(1, C1:E2, 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.

© 2025 Better Solutions Limited. All Rights Reserved. © 2025 Better Solutions Limited Top