You don't need SUMPRODUCT, just use the COUNTIFS function.
Your last criteria in the COUNTIFS argument makes no sense to me. Explain your criteria for counting.