FUNCTION CATALOGUE / LOGICAL / ARRAY
REDUCE Excel function
Reduces an array to an accumulated result.
Correct sentence to use
Reduce [array] using [accumulation rule].
Modify this query in PlainFormula →Example formula
=REDUCE(0,A2:A10,LAMBDA(a,v,a+v))
Accumulates values through an array.
Syntax
REDUCE([initial_value], array, lambda)
Argument signature: [initial_value], array, lambda
Availability note
Available in supported Microsoft 365 / newer Excel versions; verify the exact release and platform.