title: How to autosum a full column in excel without circular reference?
body: <p><img src="https://i.stack.imgur.com/Mao5B.jpg" alt="enter image description here"></p>
  
  <p>I would like to have in the red circle cell (<strong>C19</strong>) the sum of all the C column. I've tried using C1 to C50 in the formula (<code>=SUM(C1:C50)</code>). I use C1:C50 and not C1:C18 because if I add some lines before the final sum I would like those to be included in the final sum.</p>
  
  <p>So 2 questions:</p>
  
  <p>1) How can sum all the C column without only C1 (which is a date) and without C19 (to not cause the circular reference, since that is the cell where just the previous values should be sum and presented?</p>
  
  <p>2) If there's a formula for that, would it auto-update if I add more lines (let's say I add another line and the final sum changes to C20)? Then C19 should also be add to the sum.</p>
  
  <p>PS: the image is showing the formula for the B column because I will use the same formula in all columns, I just asked about C because there I have a working sum.</p>