A3 =SUM(INT(RAND()*$A$2+1),INT(RAND()*$A$2+1),INT(RAND()*$A$2+1),INT(RAND()*$A$2+1),INT(RAND()*$A$2+1),INT(RAND()*$A$2+1),INT(RAND()*$A$2+1),INT(RAND()*$A$2+1),INT(RAND()*$A$2+1),INT(RAND()*$A$2+1))或分两步做,在B1输入公式 =INT(RAND()*$A$2+1) 下拉至B10或B100,视A1的数字为行数A3输入公式 =SUM(B1:B10) 或 =SUM(INDIRECT(quot;B1:Bquot;A1))
查看原帖
|