Updating workbook formulas for additional variables

Hello,

I had assistance making the attached workbook years back and I am looking to additional variables.

On the worksheet "Summary" there are options to lookup an employee's data on the "Data" worksheet.

This can be narrowed down by entering a start date and end date or using a trackback option for number of days back to look.

The results are displayed in A4:H1000.

On the worksheet "Data" in column G there are helper formulas.

I am trying to add two additional filters to the "Summary" worksheet.

One for Shift and one for Type.

My attempt to update these two formulas causes errors:
=IF(OR(ROWS($B$4:$B4)>$H$1,$C$1="",COUNTBLANK($D$2:$D$2)=2),"",INDEX(Data!B:B,MATCH(ROWS($B$4:$B4),Data!$G:$G,0)))

=IF(Summary!$F$1="",IF(Summary!$C$1="All",SUMPRODUCT(--(A$2:A2>=Summary!$B$2),--(A$2:A2<=Summary!$D$2)),SUMPRODUCT(--(B$2:B2=Summary!$C$1),--(A$2:A2>=Summary!$B$2),--(A$2:A2<=Summary!$D$2))),IF(Summary!$C$1="ALL",SUMPRODUCT(--(A$2:A2>=TODAY()-Summary!$F$1),--(A$2:A2<=TODAY())),SUMPRODUCT(--(B$2:B2=Summary!$C$1),--(A$2:A2>=TODAY()-Summary!$F$1),--(A$2:A2<=TODAY()))))

I appreciate any help in adjusting these formulas.

Thank you,
Nick