title: Average over last 7 days formula in google sheets
body: <p>My 1-year-old son was just diagnosed with Type 1 Diabetes, and I am trying to create a spreadsheet to track his sugar levels etc. I have the dates in column A, and his blood sugar levels in column C. I have been trying for the last couple days to figure out how to get his average blood sugar levels for the last 7 days, and just keep getting errors. I have searched google extensively, and have found some similar examples, but can never seem to get them to work. </p>
  
  <p>This is what I have at the moment, but I get a Divide by zero error. </p>
  
  <pre><code>=averageif(A7:A, "&gt;=" &amp; (TODAY()-6),C7:C)
  </code></pre>
  
  <p>I would greatly appreciate any help with this.</p>