=SUMPRODUCT
If you're looking to get individual counts for "Closed", "Not Started", and
"In Progress", just copy your original formula to another cell and change
"Closed" to one of the other values.
Example:
=SUMPRODUCT(--($B$1:$B$23=F1)*($C$1:$C$23="Not
Started")*($A$1:$A$23=$I$2)*($A$1:$A$23<=$J$2))
However, if you are looking for a single count of all items that are either
"Closed", "Not Started", OR "In Progress", then take a look at my response in
your "count if" thread.
Does that help?
***********
Regards,
Ron
XL2002, WinXP-Pro
"Jim" wrote:
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.
|