filtering and sum....

[drdree73]

Hi, 

I have a column with over 1000 data text entries, where not all entries are unique.

Is there a method to automatically filter the unique entries and SUM the corresponding cells in next column (see yellow cells in below figure as example).

Many thanks!

[#2 · Accepted solution]

@drdree73 

=LET(a,UNIQUE(B3:B17),b,SUMIF(B3:B17,a,C3:C17),CHOOSE({1,2},a,b))

Maybe with this formula. 

[#3]

@OliverScheurich , got it working! awesome! thank you!

[#4]

this is really the best way to do this? I want to do the same thing but with a LOT more elements so this equation is kind of cumbersome....it seems odd to me this isn't a common need and there isn't some way in excel to do this a lot easier???