title: Sum row values based on horizontal and vertical criteria
body: <p>I am looking to sum values in a row based on a horizontal month range and vertical name range.</p>
  
  <p>Here is what I am trying to achieve:</p>
  
  <pre><code>**Name**     1       2      3       4       5             
  Michael  $24,000 $36,000 $24,567 $45,000 $36,900    
  Jerry    $27,000 $39,090 $55,567 $85,000 $39,900    
  Sandra   $24,000 $36,000 $24,567 $45,000 $36,900    
  Michelle $24,000 $36,000 $24,567 $45,000 $36,900
  </code></pre>
  
  <p>I want to be able to sum based on the month range.</p>
  
  <p>For example, If I want to know what the value is for Sandra in months 3-5 ($24,567 + $45,000 + $36,900)</p>
  
  <p>So everytime I play around with the range it should give me the sum of those values.</p>
  
  <p>I tried an index match match function but I could only do it for a specific month not a range. </p>
  
  <p>This was the formula I used : </p>
  
  <pre><code>=INDEX(Quota!$A$3:$P$29,MATCH('Summary by Rep'!A7,Quota!$A$3:$A$29,0),MATCH('Summary by Rep'!B4,Quota!$A$3:$P$3,0))
  </code></pre>
  
  <p>Any help would be greatly appreciated!</p>