title: Feeding Multiple Distant Cells as One Array in Excel?
body: <p>I have the following table in Excel.</p>
  
  <pre><code>   A B C D                        E
  1  i x y mu                       sigma
  2  0 1 2 =average(b$1:b1,b3:b$12) =stdev.s(b$1:b1,b3:b$12)
  3  1 3 4 =average(b$1:b2,b4:b$12) =stdev.s(b$1:b2,b4:b$12)
  4  2 2 1 =average(b$1:b3,b5:b$12) =stdev.s(b$1:b3,b5:b$12)
  5  3 1 2 ...                      ...
  6  4 2 5
  7  5 4 7
  8  6 8 1
  9  7 2 3
  10 8 5 9
  11 9 1 3
  </code></pre>
  
  <p>The ith mu calculates the average without the ith observation—the leave-one-out average. I can also calculate the leave-one-out standard deviations, but how can I do this for the leave-one-out correlations then? <code>correl</code> requires two arrays and I cannot feed two or more distant cells as one array using commas. Can I input non-consecutive cells as one array? For example, I tried <code>=correl((b$1:b1,b3:b$12),(c$1:c1,c3:c$12))</code>, but failed. Thanks for your reading.</p>