I have ~3000 lines of data. Column D includes an incident date for data
collected over the entire current year. Column E includes an incident type
(there are ~20 varieties). Column F includes the incident status (3 types).
I need to come up with a formula (or multiple) to count the number of times a
specific incident type occurs within the current month for each of the three
incident status types (APPR, CLOS, SUBM). I was expecting to have a formula
for each status type and each variety of incidents. I also have to do the
same counting for the current week.

When I was doing the year to date information I used a sumproduct as follows:

=SUMPRODUCT(($E$35:$E$1000="PROPERTY DAMAGE/VANDALISM
")*($F$35:$F$1000="APPR "))

Any help would be appreciated.

Thanks in advance.