Count values in a row pertaining to a specific date range column

I’ve been struggling with this and need some help…

Column A is a range of dates, columns B thru E whether a room is in compliance or out of compliance for that specific date. For B-E contains the following data:

“1” represents compliance.
“0” represents non-compliance.
Anything else (“np” or a blank space, or other text should be ignored)

There can be repeat and skipped dates (as seen in screenshot). I need to be able to specify a range of dates and then obtain the compliance rate for those dates.

Right now I’m using =Countif, and manually selecting my range every time. The problem is that this spreadsheet has 1000s of entries and I need to frequently change a long list of dates that I’m looking at. What I want to be able to do is choose a start and end date, and then obtain my compliance rate for that date range. Below is an example of the spreadsheet. Thank you for any help!

COUNTIF() is good for checking data with one criteria.
COUNTFS() is good for checking data with more than one criteria.

A: Dates

M1: Start Date
N1: End Date

=COUNTIFS(A:A, ">="&M1, A:A, "<="&N1)

Something like that....

Sumproduct then, you can't use a whole column for this function:

=SUMPRODUCT(($A$1:$A$21>=START_DATE)*($A$1:$A$21<=END_DATE)*($B1:$E21=1))

Maybe add in:

SUMPRODUCT(($A$1:$A$21>=START_DATE)*($A$1:$A$21<=END_DATE)*($B1:$E21=0)*(LEN($B1:$E21)>0))