隨機產生 指定總和 格數 (10892)

B4:B18區域數組 右拉{=IF(ROW(1:15)>B2,"",MMULT(N(TRANSPOSE(RANDBETWEEN(ROW(INDIRECT("1:"&B1))^0,B2))=ROW(INDIRECT("1:"&B2))),ROW(INDIRECT("1:"&B1))^0))

B20:F20=SUM(B4:B18)