總和排名 先複雜取值 (13109)

D3=SUMPRODUCT(B$12:B$17*(C$12:E$17=A3))*C3

H3:I7{=OFFSET($B$2,RIGHT(LARGE($D$3:$D$7/1%+ROW($1:$5),ROW(A1))),(A$2=$B$2)*2)