Which column contains the dates?
Your countifs is looking at E but sumproduct is looking at F.

Are your dates really dates?
Use =ISNUMBER(E3) to test
If its true its a real date