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.

	A	B
1	=RANDBETWEEN(5,10)→	5
2	=RANDBETWEEN(5,10)→	6
3	=RANDBETWEEN(5,10)→	7
4	=RANDBETWEEN(5,10)→	6
5	=RANDBETWEEN(5,10)→	9
6	=RANDBETWEEN(5,10)→	7
7	=RANDBETWEEN(5,10)→	10
8	=RANDBETWEEN(5,10)→	5
9	=RANDBETWEEN(5,10)→	6
10	=RANDBETWEEN(5,10)→	9
11	=SUM(B1:B10)→	70

<tbody>
</tbody>

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!