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