title: Excel Solver: Solving based on an average
body: <p>I have a parameter in <strong>A1</strong> that influences "<strong>TOTAL</strong>" in a random and very high standard deviation. Lets say <strong>A1</strong> is 2...then <strong>TOTAL</strong> Values could be 1...5...17...3...2..2...etc If <strong>A1</strong> is 1 then <strong>TOTAL</strong> Values could be 1....3...5..15...9...10..etc</p>
  
  <p>I would like solver to figure out which value in <strong>A1</strong> would equate to the best AVERAGE of <strong>TOTAL</strong> after <strong>X</strong> runs. Where I can define <strong>X</strong>.</p>
  
  <p>In my example you can tell that <code>A1=1</code> is better on average after <strong>6</strong> runs. However, if you run solver normally it would say <code>A1=2</code> is the best, because it produced a value of 17.</p>