Sql Excel : AGGREGATE: Aggregating Values

The AGGREGATE operator groups its input based on zero or more key columns.
All the rows with the same key values are summarized into a single row, and the
output contains the aggregate key columns and the summaries. The AGGREGATE
operator takes one input and produces one output. It also takes parameters
describing the aggregate keys and the summaries to produce.