隨機產生 指定總數與格數 (13624)

E2:E16區域数组公式{=IF(ROW(1:15)>C2,"",MMULT(N(RANDBETWEEN(TRANSPOSE(ROW(INDIRECT("1:"&C1))^0),C2)=ROW(INDIRECT("1:"&C2))),ROW(INDIRECT("1:"&C1))^0))

F2=SUM(E:E)