excel - SUMIFS based on name and date range -

I try to get a formula to sum values ​​of cells based on two parameters, date range and name I am here.

Column A has the text in the date, column B, the employee's name is included in column C, from column E "quantity" on the basis of criteria by column H "date" and column "employee" Need to be added to different WS values ​​", column D has text, column E contains the number (this is what I need to add), employee # in column F, number and column in column G H are included. Rows go from 2 to 100.

I tried to search "VLOOKUP" for "employee's name" and SUMIFS for date range, but I am unable to add both formulas for the desired result.

Try "Sheet2" with "itemprop =" text ">

Try it,

  = sumifs ('Sheet 2'! E: e, 'Sheet 2'! F: F, B1, 'Sheet 2'! H: H, "& gt; =" & amp; A1, 'Sheet 2'! H: H, "& lt;" (A1, 1))