Sum Random Numbers in A1:a20 to equal B1

[Stephen_IV]

Is it possible to have a group of random numbers equal a value, even when consistantly pressing F9? For instance, in range A1:A20 I would like random numbers, in cell B1 I would like to have 50. What I would like is for the 20 random numbers to add up to 50 Even if I consistantly press F9. If I change B1 to 63 I would like the 20 random numbers to add up to 63.

Please Help,

Stephen

Thanks in advance!

 

[cornflakegirl]

You could use =RAND() in A1 to A20. Put 50 in C1. Then in B1 put =$C$1/sum($A$1:$A$20)*A1 and copy down.

This won't give you genuine random numbers in B1 to B20 - but they'll be random in relation to each other...