title: Calling a formula on union of two ranges
body: <p>I have some numbers in cells <code>A1:A10</code> and some more numbers in <code>B1:B7</code>.</p>
  
  <p>I want to run a function that takes a range (like <code>IRR</code> or <code>SUM</code>) such that it will operate on the concatenation of those two ranges. Is there a way in Google Spreadsheets to make such a call?</p>
  
  <p>For <code>SUM</code> there is the obvious workaround <code>SUM(A1:A10)+SUM(B1:B7)</code>, but this wouldn't do for a function like <code>IRR</code>.</p>