Aggregate utility functions are utility functions that perform aggregations on grouped data using Excel aggregate functions, such as AVERAGE, COUNT, COUNTA, COUNTIF, COUNTIFS, LARGE, STDEV, SMALL, SUM
etc.

Examples of aggregate utility functions

GroupBy

Pivot

Examples using aggregate utility functions

Groupby using Sum, Average and Large

Groupby using Count

Pivot using Sum

Pivot using Average