得分 1~4 次數 (9156)

K2:N5=SUM(COUNTIFS($A:$A,$J2,OFFSET($A:$A,,{1,2,3,4,5}),COLUMN(A1)))

另 解=SUMPRODUCT(($B$2:$F$9=COLUMN(A1))*($A$2:$A$9=$J2))