ExcelFlux

REDUCE function

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

Logical · Excel 2024+ · Guided Excel example

Where can you use it?

Teams building reports and business rules. Adapt the example’s decision rule when you need to test a condition or display different results based on it.

Scenario in the workbook

Add the array values to an opening balance. Only the final accumulator is returned.

A worked example from the workbook

RowABC
6ValuePositionReading
7114
8429
97314
Record 1
=REDUCE(A7,$B$7:$B$9,LAMBDA(acc,val,acc+val))

Illustrative output7

See the inputs and instructions for all 3 examples

Worked examples

Add the array values to an opening balance. Only the final accumulator is returned.

Column F provides expressions as text. Satisfy the stated requirements, then paste into an empty Excel cell and compare with column G. The result was not verified in desktop Excel here.

Row A B C
6 Value Position Reading
7 1 1 4
8 4 2 9
9 7 3 14
Trial Expression Sample output
Record 1 =REDUCE(A7,$B$7:$B$9,LAMBDA(acc,val,acc+val)) 7
Record 2 =REDUCE(A8,$B$7:$B$9,LAMBDA(acc,val,acc+val)) 10
Record 3 =REDUCE(A9,$B$7:$B$9,LAMBDA(acc,val,acc+val)) 13
Microsoft Excel reference