Skip to content

REDUCE

Dynamic arraysMicrosoft 365

Fold an array down to a single accumulated value.

Syntax

REDUCE([initial_value], array, lambda)

Examples

=REDUCE(0, tokens, LAMBDA(acc, t, acc & t))

→ concatenate a list

Related functions

SCANMAPLAMBDA

More Dynamic arrays functions

BYCOLBYROWCHOOSECOLSCHOOSEROWSDROPEXPANDFILTERGROUPBYHSTACKMAKEARRAYMAPPIVOTBY

← All 510 functions

Syntax follows Microsoft’s documentation. Examples are written to be pasted into a cell and checked. Argument separators may be ; in your locale. The AI explainer runs on a free community model — verify anything important.