# AGGREGATE

#### 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*.

<figure><img src="https://3148043601-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FL43fiRbeRtPnTjMpbGNO%2Fuploads%2Fgit-blob-e9193fc374562c606ec1a8567f557add93d992d1%2Fgrafik%20(260).png?alt=media" alt=""><figcaption></figcaption></figure>