title: SUMIFS with date and name criteria... month and year only
body: <p>I am trying to get a SUMIFS formula to check a column of dates and sum only the values that correspond to the matching year and month of the criterion date. I would also like this SUMIFS to include a name criterion along with the date. i.e.</p>
  
  <p>Cell A1: <code>=SUMIFS('Sheet1'!O:O, 'Sheet1'!D:D, 'Sheet2'!DATE(B2), 'Sheet1'!E:E, "Name")</code></p>
  
  <p>sheet1 column O is where the sum values are stored<br>
  sheet1 column D is where the date values are stored<br>
  sheet2 cell B2 is where the date comparison criterion is stored<br>
  sheet1 column E is where the names are stored<br>
  "Name" is the name criterion that I want for sum selection</p>
  
  <p>Any insight will be most appreciated!</p>