title: "Resetting" Average in Excel
body: <p>Please pardon my poor explanation of my problem, any insight would be greatly appreciated. </p>
  
  <p>I am using an average in excel that begins at a fixed cell and fills down.
  For example: column B contains values, and column C contains the formula =AVERAGE($B$1:B1) filled down, so at row 10 the formula is =AVERAGE($B$1:B10)</p>
  
  <p>I am wondering if there is a way to calculate this average that will "reset" when the value in the column A changes. Getting a formula for whether column A changes is easy using an IF function but I don't know how to change the reference cell when the average "resets." I attempted to attach an image with the formulas but I do not have 10 reputation so here is a link to a short example sheet:</p>
  
  <p><a href="https://drive.google.com/file/d/0BymZUcneHsYgUnRoYkRkdnJYbmM/view?usp=sharing" rel="nofollow">https://drive.google.com/file/d/0BymZUcneHsYgUnRoYkRkdnJYbmM/view?usp=sharing</a></p>
  
  <p>I would prefer do accomplish this without VBA if possible.</p>
  
  <p>Thank you very much. </p>
  
  <p><strong>EDIT:</strong> would it be possible to have a count function next to the data column that starts over when column A switches from "A" to "B" (or "B" to "A"), then I could simply use an average offset with the resulting value to get the desired average?</p>