title: Google Sheets: extract one column of a named range
body: <h2>update</h2>
  <p>My original question was about taking the average of a single column of a named range.  But upon reflection, the question generalizes to &quot;how do I extract a single column from a named range?&quot;</p>
  <h2>original question</h2>
  <p>I'm using a named range to extract two columns from a large dataset.  Assume <code>MyRange</code> defines three rows and two columns out of a larger dataset:</p>
  <pre><code> ... |G   |H   | ...
  +----|----|----|
  | ...          |
  |2000|15.1|  10|
  |2001|15.2|  23|
  |2002|15.3|  30|
  | ...          |
  </code></pre>
  <p>Using <code>MyRange</code>, how would I take the average of (only) column <code>H</code>?<br />
  I've tried various things like <code>AVERAGE(MyRange:H)</code>, and <code>AVERAGE(INDEX(MyRange 1))</code> but haven't figured out the proper syntax.<br />
  <em>(In the above example, the result should be 21.)</em></p>