加總後 全部與指定排名 (15041)

J2=SUM(N(MMULT(B$2:I$16,Z1:Z8+1)>SUM(B2:I2)))+1

K2{=SUM(N(MMULT(B$2:I$16*COUNTIF(N:N,B$1:I$1),Z1:Z8+1)>SUM(COUNTIF(N:N,B$1:I$1)*B2:I2)))+1

L2=SUMPRODUCT(COUNTIF(N:N,B$1:I$1)*B2:I2)