Countif (or maybe it's Sumproduct?) meets two criteria and between two dates

Hello All,

See attachment.

Attendance Records will be my running data that I will continue to populate. This will contain the department, date and event.

Overview is where I would like to see my totals.

In the chart, Overview, I would like the formula to match the department and the event description above in row 5. Then count the number of times that department and event occur between the dates in row 3 and 4.

Thank you in advance,