title: Sum/Count Formulas auto adjust for inserted rows
body: <p>Looking to create a sum and a count formula that will automatically adjust itself for new rows that are inserted within the range. </p>
  
  <p>For example if I have the formula in cell D55 <code>=SUM(D17:D54)</code>. Every time I insert a new row within that range, I need to change the top range of my formula to account for it. </p>
  
  <p>Is there a way to write a formula that will automatically adjust itself, so that every time I add a new row I will not need to change my summation formula?</p>