title: Sum imported range row-wise
body: <p>I have a table with data in three columns, lets say from E26 to G47. What I want is to display the row-wise sum of this data in another spreadsheet, so the cell E26 of the other spreadsheet contains the sum of E26 to G26 from the first sheet. I tried to implement it in code, but I was unsuccessful:</p>
  
  <pre><code>=SUM(ImportRange("key"; "sheet!E26:G47"))
  </code></pre>
  
  <p>This sums the whole data of rows and columns in one cell.</p>
  
  <pre><code>=SUM(ImportRange("key"; "sheet!E26:G26"))
  </code></pre>
  
  <p>This does nothing.</p>
  
  <p>How can I achieve this? Thanks!</p>