Exceljet

Quick, clean, and to the point

Aggregate operation

Examples of aggregate operations in Excel

An aggregate operation is an operation that returns a single value. For example, given a range of data, the following formulas return a single result, even when the data provided contains hundreds or thousands of values.

=MAX(data)
=MIN(data)
=COUNT(data)
=AVERAGE(data)
=SUM(data)

Common functions that perform aggregate operations include, MAX, MIN, COUNT, COUNTA, AVERAGE, AND, OR, and SUM.

In many cases, an aggregate value is the desired result. However, because Excel can handle arrays and array operations, there are situations where a single value is not desired