隨機20格總和 1000 (10232)

A2:T2 區域數組公式  下拉 {=MMULT(TRANSPOSE(ROW($1:$1000)^0),N(RANDBETWEEN(ROW($1:$1000)^0,20)=COLUMN($A:$T)))

V2:V9=SUM(A2:T2)