排名 區總數量 (9739)

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

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