Generate N random numbers whose sum is a constant K – Excel

by

You could use the RAND() function to generate N numbers (8 in your case) in column A.

Then, in column B you could use the following formula B1=A1/SUM(A:A)*320, B2=A2/SUM(A:A)*320 and so on (where 320 is the sum that you are interested into).

So you can just enter =RAND() in A1, then drag it down to A8. Then enter =A1/SUM(A:A)*320 in B1 and drag it to B8. B1:B8 now contains 8 random numbers that sum up to 320.

Sample output:

enter image description here

More Related Contents:

  1. Save excel file multiple times with file names in another workbook.
  2. Is it possible to force Excel recognize UTF-8 CSV files automatically?
  3. Function to convert column number to letter?
  4. Read/Parse text file line by line in VBA
  5. Excel VBA: Answer gets “stuck”
  6. 2 Dimensional array from range [closed]
  7. filter out multiple criteria using excel vba
  8. Excel VBA autofilter all but three
  9. Cells.Find() Raises “Runtime Error 91: Object Variable or With Block Not Set”
  10. Java Generate Random Number Between Two Given Values [duplicate]
  11. Generating CSV file for Excel, how to have a newline inside a value
  12. Excel VBA code to copy a specific string to clipboard
  13. Excel VBA – Range.Copy transpose paste
  14. How to use FindWindow to find a visible or invisible window with a partial name in VBA
  15. How do you get a Range to return its Name?
  16. Excel VBA: Convert a date string to a Unix timestamp
  17. What does — do in Excel formulas?
  18. Insert picture into Excel cell [closed]
  19. Excel Formula to SUMIF date falls in particular month
  20. In Excel, can I use a hyperlink to run vba macro?
  21. Excel VBA – exit for loop
  22. Can I export excel data with UTF-8 without BOM?
  23. Extract the last substring from a cell
  24. Best way to protect Excel VBA code? [closed]
  25. Why does Excel not round according to 8-byte IEEE 754
  26. VBA: Remove duplicates fails when columns array is passed using a variable
  27. Changing YYYYMMDD to MM/DD/YYYY
  28. Is it possible to see more than 65536 rows in Excel 2007? [closed]
  29. Concatenate multiple ranges using vba
  30. How to fix a VBA “type mismatch” error after switching to 64-bit Excel

Leave a Comment