Sum distinct function

How can I do a sum distinct function in the worksheet? I’m looking for Sigma’s equivalent to Snowflake’s sum distinct function:

Hey Kristian!

I think the SumIf() function should do the trick for you, this sums up values only if a certain condition is met. Check out the help article below on how to use this!

I don’t know if we can specify distinctness as a condition in SumIf(). You may have to first create a grouping level for the column in question and then call Sum() or SumIf() from a higher level.