title: How do I specify a variable Excel range?
body: <p>I'd like to be able to dynamically specify a range in Excel, based on row/column variables.</p>
  
  <p>Let's say I have a file with contents that look sort of like this:</p>
  
  <pre>
     A   B   C   D   E
  1  10  11  12  13  14
  2  51  52  53  54  55
  </pre>
  
  <p>If I wanted to sum the items in row 1, columns 2-4 (i.e. 11 + 12 + 13), how would I specify that?</p>
  
  <p>If I were doing it by hand, I'd type:</p>
  
  <pre><code>=SUM(B1:D1)
  </code></pre>
  
  <p>...but how do I programatically generate that range definition on the fly, knowing only the wanted row (1) and column numbers (2-4)?</p>
  
  <pre><code>=SUM(????)
  </code></pre>
  
  <p>Thanks in advance for your help!</p>
  
  <p>(I'm using Microsoft Excel 2011 for Mac, so Excel VBA/macro-based solutions won't work for me.)</p>