title: Is there a way to control the start point and range of the average function with a cell
body: <p>I have some numerical data in a column, I want a 'user' to be able to select the starting cell and the last cell or range of the average. </p>
  
  <p>I have tried using a combination of the average function and the choose function. I have also tried using AVERAGEIF.</p>
  
  <pre><code>=AVERAGEIF(C2:C121, 5, C2:C6)
  </code></pre>
  
  <p>I would like to assign the range within the larger range to a user selected variable. (By the user changing one number preferably)</p>