title: SpreadsheetApp how to use variable inside formula
body: <p>I want to be able to put my variable row into the</p>
  
  <pre><code>.setValue("=SUM(B54:BA54)")
  </code></pre>
  
  <p>Actually I need the value of row to replace <code>B54:B54</code>. I'm looking for something like</p>
  
  <pre><code>.setValue("=SUM(B+row+:BA+row)")
  </code></pre>
  
  <p>So if <code>row = 50</code> the <code>setValue</code> will put <code>=SUM(B50:BA50)</code> in the cell</p>
  
  <pre><code>var text3 = result3.getResponseText();
  var row = parseInt(text3);
  activeSheet.getRange(row+3,55).setValue("=SUM(B54:BA54)");
  </code></pre>