加總排名 多區順序不同 (15129)

H2:H9{=INDEX(B:B,RIGHT(LARGE(IF(COLUMN(A:CT)<=8,MMULT(COLUMN(A:CT)^0,MMULT(N(+C$2:F$99),{1;1;1;1})*(B$2:B$99=TRANSPOSE(B$2:B$99)))/1%+COLUMN(B:CU)),ROW(A1)),2))

I2:I9=SUMPRODUCT((B$2:B$19=H2)*N(+C$2:F$19))