Countif for date ranges

Hi,

I've uploaded a sample of the worksheet.

The list tab is the worksheet to draw the data from and the Overview tab is what I'm trying to achieve.

So the first goal is number of materials demanded before PIR which arrived on or before the drop dead date.

So the date for PIR is in D2

The demand date is H5:H64

Drop Dead Date is I5:I64

SO it needs to count H5:H64 if <D2 and <=I5:I64

If there is a solution that doesn't return 0 I'd be very grateful!