title: Get values from last 3 non-blank cells in a row
body: <p>I currently have an excel worksheet similar to the following (<em>#'s represent blank cells</em>)</p>
  
  <pre><code>1   2   3   4   5   6   7
  37  21  30  32  25  22  34
  #   17  26  28  27  17  31
  #   #   #   #   #   #   38
  25  23  27  35  33  #   #
  27  11  23  #   #   #   #
  </code></pre>
  
  <p>In column 8 I need the sum of the last 3 non-blank cells (the number of columns is increased regularly).</p>
  
  <p>An example of what I need to achieve is below:</p>
  
  <pre><code>1   2   3   4   5   6   7       8
  37  21  30  32  25  22  34      25+22+34=81
  #   17  26  28  27  17  31      27+17+31=75
  #   #   #   #   #   #   38      N/A
  25  23  27  35  33  #   #       27+35+33=95
  27  11  23  #   #   #   #       27+11+23=61
  </code></pre>
  
  <p>I have managed to get very close with the <code>LARGE</code> function but obviously this only give me the 3 largest, not the last 3 non-blank:</p>
  
  <pre><code>=(LARGE(C3:J3,1)+LARGE(C3:J3,2)+LARGE(C3:J3,3))
  </code></pre>