老師偷懶 只填總分 五科隨機產生數字 (13792)

B2:F2區域數組公式 下拉{=MMULT(TRANSPOSE(ROW(INDIRECT("1:"&G2))^0),N(RANDBETWEEN(ROW(INDIRECT("1:"&G2))^0,5)={1,2,3,4,5}))

H2:H16=SUM(B2:F2)