The AGGREGATE function has two syntaxes—one for references and one for arrays—though you don't need to get yourself tied up in knots over which one you're using, as Excel selects the relevant ...

Because the GROUPBY function returns spilled arrays, you can't use formatted Excel tables for their results ... In other words, categories aren't nested, which is why you also can't include ...