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 * For the Google documentation refer to support.google.com |
|
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