Hi!

Here's one way....

Extend the RAND formula in column A down to A20000

Hit function key F5 and enter A1:A20000
Click OK

In the formula bar type in =RAND() and hit CTRL ENTER

That will put the RAND formula in the range A1:A20000

Hit F5 again and enter C1:C1000
Click OK

In the formula bar type in this formula and then hit CTRL ENTER

=SUM(OFFSET(A$1,(ROW()-1)*20,,20))

That will put 1000 random sums of 20 cells each in the range C1:C1000

Biff

"vegas" wrote in
message ...

For Example,
From column A1 to A20 I assign 20 random numbers (A1=rand(), A2=rand(),
.. A20=rand()).
Then I put B1=sum(A1,A2,...,A20)
Every time I press "F9", I got a outcome of B1
Now I want to get the outcome 1000 times, and assign the data to other
columns such as C11 to C10000. How to do that?


--
vegas
------------------------------------------------------------------------
vegas's Profile:
http://www.excelforum.com/member.php...o&userid=25091
View this thread: http://www.excelforum.com/showthread...hreadid=386025