title: Generate N random numbers whose sum is a constant K - Excel
body: <p>How can I generate those numbers in Excel.</p>
  
  <p>I have to generate 8 random numbers whose sum is always 320. I need around 100 sets or so.
  <a href="http://en.wikipedia.org/wiki/User:Skinnerd/Simplex_Point_Picking" rel="noreferrer">http://en.wikipedia.org/wiki/User:Skinnerd/Simplex_Point_Picking</a>. Two methods are explained here.</p>
  
  <p>Or any other way so I can do it in Excel.</p>