會考計算分數 (10127)

D2:D21=SUM(MMULT(COLUMN(A:G)^0,N(A2:C2>=G$2:I$8)))

M2:O21{=OFFSET($K$1,MATCH(,0/(A2>=G$2:G$8),),)

P2:P21=SUM(M2:O2)