title: Sumif not returning value
body: <p>Hi I have two worksheets. Worksheet A looks like this:
  Q1 is supposed to sum up values from worksheet B between 7/1/2015 and 9/30/2015</p>
  
  <pre><code>    Name |  Q1
  Doe, John|  15
  </code></pre>
  
  <p>With more rows and columns added on.</p>
  
  <p>Worksheet two looks like this</p>
  
  <pre><code>Date     | Doe, John | ...
  7/1/2015 | 3         | ...
  7/2/2015 | 3         | ...
  7/3/2015 | 3         | ...
  7/4/2015 | 3         | ...
  ...                  | ...
  9/30/2015| 3         | ...
  </code></pre>
  
  <p>Where the date column is each date incremented by one day, and each row is with each name of a person.</p>
  
  <p>I'm trying to sum up the numbers between two dates in worksheet A, and am trying the sumifs function, but it doesn't seem to work. The formula I have is:</p>
  
  <pre><code>=sumifs(Attendance!$B$2:$BS$552, Attendance!1:1, Summary!$A2, Attendance!A:A, and(Attendance!A:A&gt;"7/1/2015", &lt;"10/1/2015"))
  </code></pre>
  
  <p><strong>Basically what I'm trying to do is find out what column Doe, John is in and then sum up all the values in that specific column within a given boundary.</strong> The only way that I know how to do it dynamically (without using macro) is to do offset, but that doesn't return a row name it would return a row index. It doesn't really help me to know that Doe, John is in index 2, because if I want to sum up all the values in the 2nd column I need to do something like sum(B:B), not sum(2:2)</p>