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.


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