Home > Mobile >  Excel : Sum of Unique values of corresponding column in the filter - Multiple columns in between
Excel : Sum of Unique values of corresponding column in the filter - Multiple columns in between

Time:11-10

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)))

enter image description here

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.

  • Related