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.