Hi!

Try this:

=SUMPRODUCT(--(D1:D50000=C6),--(ISNUMBER(MATCH(G1:G50000,{"Closed","In
Progress","Not Started"},0))),--(A1:A50000=AN1),--(A1:A50000<=AO1))

Biff

"Jim" wrote in message
...
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.