GROUPBY aggregating more than one column of data

Copper Contributor

In the early versions of Excel beta, we were able to create a formula like this:



=GROUPBY(Table[Code], Table[[Duration]:[Expense]], SUM, 3)



and this worked just fine.


But now, the lambda SUM function is coming up with a #NAME error, even when I use the formula builder.


Excel version:

Microsoft Excel for Microsoft 365 MSO (Version 2404 Build 16.0.17521.20000) 64-bit


Example attached.

0 Replies