deepcalc
DocsREDUCE

REDUCE

View as markdown/docs/functions/reduce.md Ask Claude about this pageOpens Claude with this page's address

Reduces array to value with lambda.

  • Excel: Verified match
  • Google Sheets: Verified match
  • Returns: Any value

Examples

=REDUCE(0, A1:A3, LAMBDA(acc, v, acc + v))
A
1 10
2 20
3 30
Result 60

Syntax

REDUCE(initial_value, array, lambda)
initial_value
any required
array
range required
lambda
any required

Errors

#ERROR!
=REDUCE(0, A2:A3, LAMBDA(a,b,a+b), 1)
ARRAY_CONSTRAINTruncates a range to at most the given rows and columns. ARRAYFORMULAEvaluates an expression across a range (this engine already spills, so it is a pass-through for sheets compatibility). ARRAYTOTEXTConverts array to text representation. BYCOLApplies lambda to each column of array. BYROWApplies lambda to each row of array. CHOOSECOLSReturns the specified columns from an array.