排名 分各區 (9190)

 

  D2{=SUM(N(C2<=IF(LOOKUP(B$2:B$16,{0,6,11})=LOOKUP(B2,{0,6,11}),C$2:C$16,)))

另解 D2=SUMPRODUCT((LOOKUP(B$2:B$16,{1;6;11})=LOOKUP(B2,{1;6;11}))*(C$2:C$16>=C2))

E2=LOOKUP(D2,{1,2,3,4},{20,10,5,0})