title: Sum of referenced ranges in google spreadsheets
body: <p>In Google spreadsheets, how do I find the sum of two ranges referenced from different spreadsheets  </p>
  
  <p>I want to use something like</p>
  
  <pre><code>=(IMPORTRANGE("keyofsheet1","A1:A100")+ IMPORTRANGE("keyofsheet2","A1:A100"))
  </code></pre>
  
  <p>and get the sum</p>
  
  <p>Apparently, the above doesn't work. Any help would be appreciated :).</p>