How To Combine Duplicate Rows & Sum The Values In Excel and Sort by the Summation of Values in excel

Remove Duplicates and Sort by the Summation of Values.
IFERROR(INDEX($B$3:$B$20,MATCH(MAX(INDEX(SUMIF($B$3:$B$20,$B$3:$B$20,$C$3:$C$20)*(COUNTIF(E$2:E2,$B$3:$B$20)=0)+ROW($B$3:$B$20)/1000,)),INDEX(SUMIF($B$3:$B$20,$B$3:$B$20,$C$3:$C$20)+ROW($B$3:$B$20)/1000,),0)),"-")