WjNDF‖

SZC5j‖REDUCE

8khFD‖Applies a custom LAMBDA function to each element in a given array and accumulates results to a single value.

ebLBc‖Syntax

vWD5Y‖=REDUCE([Initial value]; Array; Formula)

tqhGj‖Initial value: Optional initial value of the accumulator.

pVjWV‖Array: The array to be reduced.

oMv4v‖Formula: a LAMBDA function that will be called on each cell of the array.

2LVhM‖The LAMBDA function requires two variables: an accumulator (e.g., a) and the array element value (v), and must be structured as follows:

LAMBDA (a, v, a + f (v))

HjCJ6‖where f(v) is a function of the individual cells of the array.

GAZG2‖Examples

MiUAf‖Example

YyThq‖The following data will be used as example

	A	B	C
1	U37rK‖Maths	EQ45W‖Physics	AEvwX‖Biology
2	47	67	33
3	36	68	42
4	40	65	44
5	39	64	60
6		38	43
7	47	84	62
8	29	80	51
9	27	49	40
10	57	49	12
11	56	33	60
12	57
13	26

XD8Tp‖The formula =REDUCE(100000;A2:A13;LAMBDA(a;v; a + v*v)) returns 120715, which is 100000 added to the sum of the squares of the Math column.

XAFa7‖Technical information

wB7Kb‖This function is available since LibreOfficeDev 27.2.

Gewrf‖This function is NOT part of the Open Document Format for Office Applications (OpenDocument) Version 1.4. Part 4: Recalculated Formula (OpenFormula) Format standard. The name space is

COM.MICROSOFT.REDUCE

BYCOL

MAP

SCAN

LvbGq‖REDUCE wiki page.