title: Sum automatically after adding new row in Excel 2013
body: <p>I am trying to use this <code>=SUM(C2:OFFSET(C10,-1,0))</code> but I am getting an error: </p>
  
  <p><code>We found a problem with this formula. Try clicking Insert function on the formulas tab to fix it, or click help for more info on common formula problems. You type: =1+1, cell shows: 2. To get around this, type an apostrophe (') first: '=1+1, cell shows =1+1.</code></p>
  
  <p>I want it to show 2, I do not want it to show the formula.. Frustrating. </p>
  
  <p>Anyone have the solution to this?</p>
  
  <p>Clarification: 
  I want a total (sum) in cell C10. I want the sum of C2 till C9. I want C10 to shift down each time I add a new row, and it automatically sums that newly added row(cell e.g. C10 now) in cell C11(total) </p>