title: SUM Function in VBA - not hard coding rows and columns
body: <p>How do I use the lastRow variable in the sum function in vba? After I count the number of words in each row until the last row, I would like to add up the individual totals from each row into an overall total column but I do not want to hard code the range into the sum function in vba? Is there another way? </p>
  
  <p>Example:              </p>
  
  <pre><code>Column:   A   B   C   D   E   F  
  NRow 1:   2   3   4   5   6   7  
  NRow 2:   3   4   5   6   7   8  
  Total 3:  5   7   9   11  13  15
  </code></pre>
  
  <p>Want to avoid <code>SUM(R[-2]C:R[-1]C)</code>? I would like <code>SUM(R[lastRow]C:R[-1]C)</code> or something that would function in the same way.</p>
  
  <p>Thank you!</p>