REDUCE
Reduces an array to an accumulated value by applying a LAMBDA to each value and returning the total value in the accumulator.
LogicalDynamic Arrays & LAMBDALogic & ConditionsModern Excel Functions
What it does
Iterates through an array, accumulating a result via LAMBDA.
Syntax
REDUCE(initial_value, array, lambda)
Arguments
initial_value(value) — Starting accumulator.array(array) — Array to process.lambda(function) — LAMBDA(acc, val).
Examples
Sum Squares
Sum of squares.
FORMULA
=REDUCE(0, A1:A3, LAMBDA(acc, val, acc + val^2))
RESULT
14
SAMPLE DATA
| A | |
|---|---|
| 1 | Data |
| 2 | 1 |
| 3 | 2 |
| 4 | 3 |