> For the complete documentation index, see [llms.txt](https://docs.nedyx.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/range-functions/aggregate.md).

# 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="/files/SWNDUAI6cJlGnl2tz3bw" alt=""><figcaption></figcaption></figure>