title: Excel - Average IF with an Offset
body: <p>I'm trying to write a formula that will Average every other cell in Row 7 starting from a 1 column offset of cell H7. I have the first part working great, but the offset is giving me trouble.  </p>
  
  <p>This formula works great to Average every other cell</p>
  
  <pre><code>{=AVERAGE(IF((I7:GQ7&lt;&gt;"")*(MOD(COLUMN(I7:GQ7),2)=1),I7:GQ7))}
  </code></pre>
  
  <p>But when we insert a new column from Column I, the formula doesn't include the new inserted column.  I'm hoping using a offset from column H will fix this problem.</p>
  
  <p>This is a scoring tracker that will be updated daily, it contains 25 rows and a bunch of columns. Everyday 2 new columns will be inserted, from Column I.  I'm hoping to make it so the formulas include the new columns without requiring daily formula edits.</p>
  
  <p>One variation to the formula, I'd like to include would be to average the last 30 as well.  Thank you for any help you can provide.</p>