title: How to express cell id using string letter and current row number in an Excel formula?
body: <p>I want to calculate the sum on a column and then subtract sum on another column <strong>BUT</strong> using only the values from a given row to the current row (the one in which formula resides).</p>
  <p>So, in an &quot;informal custom language&quot;, I would need something like this:</p>
  <p>Suppose I am in <strong>C5</strong>: <code>=(sum(A1:&quot;A&quot;+ROW())-sum(B1:&quot;B&quot;+ROW()))</code></p>
  <p>How can I write a correct expression in Excel for this?</p>