# REDUCE

## Content

This function reduces an array to an accumulated value by applying a [LAMBDA](/document-solutions/dot-net-excel-api/docs/online/Features/ManageFormulas/lambda-functions)[ ](https://support.microsoft.com/en-us/office/lambda-function-bd212d27-1cd1-4321-a34a-ccbf254b8b67)to each value and returning the total value in the accumulator.

## Syntax

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

## Arguments

| Argument | Description |
| -------- | ----------- |
| *[initial\_value]* | [Optional] Sets the starting value for the accumulator |
| *array* | [Required] An array to be reduced |
| *lambda* | [Required] A LAMBDA that is called to reduce the array. The LAMBDA takes three parameters:<ul><li>accumulator - The value totaled up and returned as the final result</li><li>value - The current value from the array</li><li>body - The calculation applied to each element in the array</li></ul> |

## Remarks

Use the *initial\_value* argument to set the starting value for the accumulator parameter.

## Examples

`REDUCE(, A1:C2, LAMBDA(a,b,a+b^2))`