Forum Discussion
Determining random numbers that add up to a predetermined sum
Hello Everyone, My goal is to create a random set of numbers that add up to a particular total. In the image below, you'll see a column of 10 numbers and its total in A12. What function would I nee...
Hi Excel
If duplicate numbers are acceptable then you can use achieve your goal by using below different formuals:
Paste =RANDBETWEEN(1,310) in A1
Paste =IFERROR(RANDBETWEEN(1,(310-SUM($C$1:C1))),0) in A2 & drag till A9
Paste =IF(SUM(C1:C9)=310,0,310-SUM(C1:C9)) in A10
You may also refer the attached file.
Thanks
Tauqeer
Hello Sir,
Thank you for giving the solution😊😊
Thank you for giving the solution😊😊