How to Create list of random numbers which gives specific total value?

[sinivasan]

How to get specific total as sum of randomly(using randbetween/rand()) generated values?

I always want to get specific value as the sum of randomly generated values

For example I have sheet as shown below.
[TABLE="class: grid, width: 250, align: left"]
<tbody>[TR]
[TD][/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD] =RANDBETWEEN(5,10)→[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD] =RANDBETWEEN(5,10)→[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD] =RANDBETWEEN(5,10)→[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[TD] =RANDBETWEEN(5,10)→[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD="align: center"]5[/TD]
[TD] =RANDBETWEEN(5,10)→[/TD]
[TD]9[/TD]
[/TR]
[TR]
[TD="align: center"]6[/TD]
[TD] =RANDBETWEEN(5,10)→[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD="align: center"]7[/TD]
[TD] =RANDBETWEEN(5,10)→[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD="align: center"]8[/TD]
[TD] =RANDBETWEEN(5,10)→[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD="align: center"]9[/TD]
[TD] =RANDBETWEEN(5,10)→[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD="align: center"]10[/TD]
[TD] =RANDBETWEEN(5,10)→[/TD]
[TD]9[/TD]
[/TR]
[TR]
[TD="align: center"]11[/TD]
[TD] =SUM(B1:B10)→[/TD]
[TD]70[/TD]
[/TR]
</tbody>[/TABLE]

From the above sheet(table) I want to get specific value as the sum of value in Column B(B1:B10 contains =RANDBETWEEN(5,10))

If I want to get 92 as my sum of randomly generated value the excel should populate the random values in column B which gives sum of 92.

How do I do it?
Could someone help me please!

 

[mikerickson]

Put =RAND() in some cells (A1:A10) for example
Put your target value, 92 in B1

put =A1*$B$1/SUM($A$1:$A$10) in C1 and drag down to C10.

C1:C10 are your random numbers that sum to 92.

 

[sinivasan]

Thanks a lot mikerickson!
I really appreciate your contribution.
I got what I wanted, thanks much!