随机数相加等于固定数 (9981)

C2:C27 區域數組公式{=TRANSPOSE(TEXT(MMULT(TRANSPOSE(ROW(INDIRECT("1:"&A2/1%)))^0,N(RANDBETWEEN(ROW(INDIRECT("1:"&A2/1%))^0,A6)=COLUMN(A:Z)))%,"0.00;;"))

E2=SUMPRODUCT((0&C2:C27)*1)