title: Index Match Only Returning First Value - Need Sum
body: <p>I've tried searching and have found nothing that helps me with this.</p>
  
  <p>I have a sheet that should display a sum of all amounts matching the corresponding date (Summary Sheet). In another sheet I have all of the data (Data Sheet).</p>
  
  <p>Summary Sheet (wrong numbers, it's only showing the first number it matches):</p>
  
  <pre><code>  |    A     |  B 
  --|----------|------
  1 | Feb 2017 | 40
  2 | Mar 2017 | 84.75
  </code></pre>
  
  <p>Data Sheet:</p>
  
  <pre><code>   |       C        |   D
  ---|----------------|-------
   1 | date_effective | amount
   2 | 2/6/2017 0:00  | 40
   3 | 2/6/2017 0:00  | -40
   4 | 2/6/2017 0:00  | 40
   5 | 2/6/2017 0:00  | -40
   6 | 2/6/2017 0:00  | 20
   7 | 2/6/2017 0:00  | -20
   8 | 2/6/2017 0:00  | 20
   9 | 2/6/2017 0:00  | -20
  10 | 2/6/2017 0:00  | 240
  11 | 2/6/2017 0:00  | -240
  12 | 3/16/2017 0:00 | 84.75
  13 | 3/16/2017 0:00 | 20
  </code></pre>
  
  <p>What the summary sheet SHOULD look like:</p>
  
  <pre><code>  |    A     |  B 
  --|----------|-------
  1 | Feb 2017 | 0
  2 | Mar 2017 | 104.75
  </code></pre>
  
  <p>This is my formula in Summary Sheet B1,</p>
  
  <pre><code>=IF(ISNA(INDEX(Table_Query_from_data[amount],MATCH(TEXT(A1,"mmyy"),TEXT(Table_Query_from_data[date_effective],"mmyy"),0))),"",INDEX(Table_Query_from_data[amount],MATCH(TEXT(A1,"mmyy"),TEXT(Table_Query_from_data[date_effective],"mmyy"),0)))
  </code></pre>