多格多數值 加總後排名 (15155)

F2=SUMPRODUCT((B$2:B$16=B2)*C$2:E$16)

H2{=IFERROR(INDEX(B:B,RIGHT(LARGE(IF(MATCH(B$2:B$16,B:B,)=ROW($2:$16),MMULT(N(B$2:B$16=TRANSPOSE(B$2:B$16)),MMULT(C$2:E$16,{1;1;1}))/1%+ROW($2:$16)),ROW(A1)),2)),"")

I2=IF(H2="","",SUMPRODUCT((B$2:B$16=H2)*C$2:E$16))