部門加總後排名 與部門各自排名 (14128)

D2=COUNTIFS(C:C,C$2:C$8,B:B,">="&B$2:B$8)

E2=SUMPRODUCT(N((MATCH(C$2:C$8,C:C,)=ROW($2:$8))*SUMIF(C:C,C$2:C$8,B:B)>SUMIF(C:C,C2,B:B)))+1