REDUCE([initial_value], array, lambda(accumulator, value))

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

[initial_value]Sets the starting value for the accumulator.
arrayAn array to be reduced.
lambdaA LAMBDA that is called to reduce the array.
accumulatorThe value totalled up and returned as the final result.
valueThe calculation applied to each element in the array

Remarks

* Added in Microsoft 365 and is only available to Office Insiders at the moment.
* This function uses the LAMBDA function.
* This function was released in July 2021.
* For the Microsoft documentation refer to support.microsoft.com

 A
1??


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