What is the GROUPBY function in Excel 365 and what scenarios does it handle that SUMIFS cannot?

Question

Microsoft Excel — Hard

What is the GROUPBY function in Excel 365 and what scenarios does it handle that SUMIFS cannot?

Accepted Answer

The GROUPBY function in Excel 365 enables dynamic aggregation of data by grouping values on specified row fields. It supports multiple aggregation functions and returns a complete summary table as a spilled array. This distinguishes it from SUMIFS, which only sums and requires separate formulas per output cell. GROUPBY's capabilities include handling sorting and filtering of results, as well as concatenating text.