I am using this formula to count the number of times €œclosed€� appears between
particular dates:

=SUMPRODUCT(--($B$1:$B$23=F1)*($C$1:$C$23="Closed")*($A$1:$A$23 =$I$2)*($A$1:$A$23<=$J$2))

I have tried applying the same logic to another formula where I wanted to
Also count the number of times €œNot Stated€� and €œIn Progress€� are shown.
However when I do I am receiving a €˜0 number in return. The formula I wrote
was:

=SUMPRODUCT(--(CS_Ticket_Report_Dump!D$1:D$50000=C6)*
(CS_Ticket_Report_Dump!G$1:G$50000="Closed")*
(CS_Ticket_Report_Dump!G$1:G$50000="In Progress")*
(CS_Ticket_Report_Dump!G$1:G$50000="Not Started")*
(CS_Ticket_Report_Dump!A$1:A$50000=AN$1)*
(CS_Ticket_Report_Dump!A$1:A$50000<=AO$1))

What am I missing?

Thanks for your help.