隨機 8數 等於總數 (11408)

E2:E9 區域數組公式{=TRANSPOSE(MMULT(TRANSPOSE(ROW(INDIRECT("1:"&B2*10))^0),N(RANDBETWEEN(ROW(INDIRECT("1:"&B2*10))^0,8)=COLUMN(A:H))))/10

B6=SUM(E:E)