Skip to content
Google Sheets

REDUCE function in Google Sheets

Reduces an array to an accumulated result by application of a LAMBDA function to each value.

=REDUCE(initial_value, array_or_range, LAMBDA)

REDUCE syntax and parameters

Three arguments, three required.

  • initial_valueanyRequired

    The initial accumulator value.

  • array_or_rangeanyRequired

    An array or range to be reduced.

  • LAMBDAanyRequired

    A LAMBDA that’s applied to each value in array_or_range to reduce it.

REDUCE examples

Formulas you'll actually reuse.

  1. A running accumulator — here a total, starting from 0:

    =REDUCE(0, D2:D200, LAMBDA(acc, x, acc + x))

    Result148200

  2. Compound five yearly growth rates into one factor:

    =REDUCE(1, B2:B6, LAMBDA(acc, r, acc * (1 + r)))

    Result1.2155

REDUCE in Excel

Same name — your formula ports as-is.

Try REDUCE in the playground

Edit the example — nothing to install.

Preloaded with the REDUCE formula from Example 1 — change anything and watch it respond.

Loading the editor…

Related functions

More ways Google Sheets gets this done.