title: How can I sum top 5 values from column in Google Sheets
body: <p>I have a simple table wherein <code>A2</code>-<code>A100</code> I have numbers. I want to sum 5 highest numbers and save in <code>A1</code>. What is a proper query to do this? I tried to do <code>QUERY</code> with <code>SELECT</code> but I couldn't enforce to sum only the top 5 numbers.</p>
  
  <pre><code>-|----------|
   | A        |
  -|----------|
  1| Sum here |
  2| 938      |
  3| 124      |
  4| 544      |
  5| 453      |
  6| 632      |
  7| 324      |
  8| ...more  |
  -|----------|
  </code></pre>