Forum Discussion

MichielS340's avatar
MichielS340
Copper Contributor
Nov 17, 2024

Excel Groupby on table with Lambda

Hi, 

In the attached document I would like to groupby on the column "type" and then sum the values of the column  "waarde" but before doing so multiply it by a certain chance (column "perc").

However I am not sure how to multiply it by the column "perc" before summing the values.

Anybody any advice on the adjustment of the groupby formula that I created in the sheet?

Many thanks in advance, 

Michiel

Excel
Formulas and Functions
office 365
  • djclements's avatar
    djclements
    Bronze Contributor
    Nov 17, 2024

    Try multiplying waarde by perc directly in the values argument of GROUPBY:

    =GROUPBY(Table1[type],Table1[waarde]*Table1[perc],SUM)
    • MichielS340's avatar
      MichielS340
      Copper Contributor
      Nov 17, 2024

      I was not aware of the values argument having this flexibility, but this would definitely be the most simple solution. Thanks for your quick advice 🙏

Resources