title: SUMIFS based on name and date range
body: <p>I'm trying to get a formula to sum values on cells based on two criteria, date range and name.</p>
  
  <p>Column A contains Date, Column B contains text, Column C Contains Employee Name, 
  I need to sum on a different WS values from column E "Qty" based on criteria from column H "Date" and column C "Employee Name", Column D contains Text, Column E contains number (this is the one I need to add up), Column F contains Employee #, Column G contains number and column H contains date. Rows go from 2 to 100.</p>
  
  <p>I've tried VLOOKUP to find "Employee Name" and SUMIFS for date range but I've been unable to combine both formulas for the desired result.</p>
  
  <p>As an example I need to sum "Qty" for Employee "Jones, Mary" during the month of March and come up with result = 5.</p>