AGGREGATE
Aggregates rows of a range based on duplicate elements.
Aggregates rows of a range based on duplicate elements.
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).
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.
