An aggregate operation is an operation that returns asingle value.
In many cases, an aggregate value is the desired result.
However, because Excel can handlearraysandarray operations, there aresituations where a single value is not desired.
Aggregate operation
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.
