I need to have Sum of values in [G] against DISTINCT values of corresponding column [C] in the filter i.e. B

I tried

SUM(UNIQUE(FILTER(G:G, (C:C)*(B:B=I2))) 

also tried

SUM(IF(Frequency)))

CodePudding user response：

Here is where using CHOOSECOL will help but you need to use that in the FILTER:

=SUM(INDEX(UNIQUE(FILTER(CHOOSECOLS(A:G,2,3,7),B:B=I2)),0,3))

Now only the three columns are passed to the FILTER output and only those three columns are looked at for the UNIQUE.