AGGREGATE

Aggregates rows of a range based on duplicate elements.

Syntax

AGGREGATE(range; aggregateCondition)

• range - the range where rows should be aggregated - Value type: range

• aggregateCondition - the criteria defining which rows should be aggregated - Value type: row range (optional, first row of range as default)

The function returns a copy of range, where all rows (or columns) which have the same according value in aggregateCondition are aggregated (combined).

Remarks

• If the cells of the aggregated rows contain numerical values, they are added up.

Examples

In this example, the second parameter can be omitted, because by default the AGGREGATE function uses anyway the first column of range as aggregateCondition.