計算得分 (10645)

K2 {=ROUND(SUM(A2:J2/(COUNT(0/A2:J2)-1)*0.5)-LOOKUP(1,0/A2:J2,A2:J2)/(COUNT(0/A2:J2)-1)*0.5+LOOKUP(1,0/A2:J2,A2:J2)*0.5,2)

另解 {=ROUND(SUM(A2:J2/(COUNT(0/A2:J2)-1)*0.5)-LOOKUP(1,0/A2:J2,A2:J2)/(COUNT(0/A2:J2)-1)*0.5+LOOKUP(1,0/A2:J2,A2:J2)*0.5,2)