Need to sum number of error by weekly and daily basis

Hello experts

I have spread sheet that contains PMT Report which shows the processors Performance Monitoring Report. which includes Monthly, Weekly And Daily Report. I have added formula for Monthly Productivity, however i don't have clue to fix the formula to calculate number of errors weekly and daily basis. Please help me.

The two columns C & D contain the dates.

I have fixed month and date range on G1 & J1 for Month, G2 & J2 on the PMT sheet for week1, G3 & J3 for day, G4 & J4 for week2, G5 & J5 for week3, G5 & J5 for week4.

In PMT sheet D32 i want to calculate the number of error(s) according to the week range.

Please help on this.

Thank you.
Marc