加總後 排名 (15214)

E2{=IFERROR(INDEX(C:C,RIGHT(LARGE(IF(MATCH(C$2:C$16,C:C,)=ROW($2:$16),SUMIF(C:C,C$2:C$16,B:B)/1%+ROW($2:$16)),ROW(A1)),2)),"")

F2=IF(E2="","",SUMIF(C:C,E2,B:B))