Skip to content
ExcelExcel 2024+

REDUCE function in Excel

Reduces an array to an accumulated value by applying a LAMBDA to each value and returning the total value in the accumulator

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

REDUCE syntax and parameters

Three arguments, two required.

  • initial_valueanyOptional
  • arrayarrayRequired
  • lambda(accumulator, value, body)anyRequired

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 Google Sheets

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 Excel gets this done.