title: Excel VBA - Sum function
body: <p>I'm trying to calculate the sum of my columns (column I). From 1 to the last record in I it has. When I record a macro I get this as output, but this is gibberish to me.</p>
  
  <pre><code>ActiveCell.FormulaR1C1 = "=SUM(R[-11]C:R[-4]C)"
  </code></pre>
  
  <p>I found another topic and there they said</p>
  
  <pre><code>LastRow = .Range("I" &amp; .rows.Count).End(xlUp).row  
  Range("I"&amp;LastRow) = "SUM(I1:I...)"
  </code></pre>
  
  <p>Except in my case, I can't figure how to enter the lastrow of I in it.
  All help is welcome :)</p>