Make an interactive workbook for my payslips

Take a look at the formula

=SUMIFS(Sheet2!$D:$D,Sheet2!B:B,">="&Sheet1!$B$3,Sheet2!$B:$B,"<="&Sheet1!$D$3,Sheet2!$C:$C,"<=na",Sheet2!$A:$A,Sheet1!$B$2)

 In words: add up the hours in column D of sheet 2 where the dates in column B is greater than or equal to the date in B3 and the dates in column B is smaller than or equal to D3 and the value in column C is different na and the period (column A) is equal to B2