隨機產生 4倍數的數量 (11257)

D2:D10區域數組 {=MMULT(N(TRANSPOSE(RANDBETWEEN(ROW(INDIRECT("1:"&H2/4))^0,9))=A2:A10),ROW(INDIRECT("1:"&H2/4))^0)

C2:C10=TEXT(COUNTIF(D:D,A2),"0;;")

C12=SUMPRODUCT(B2:B10*(0&C2:C10))