Hi,

Am Wed, 18 Jul 2012 12:33:56 +0000 schrieb Tee51:

10/12/2012 ABC/13 ACCT4 1112227 Studio
10/30/2012 ABC/13 ACCT2 1112227 Closed
12/3/2012 ABC/13 ACCT5 1112228 Pending
2/12/2013 ABC/13 ACCT6 1112229 Waiting

The count for October is 2 but I want the count to show as 1 because one
of entries is closed.

try:
=SUMPRODUCT(--(MONTH(A1:A251)=10),--(E1:E251<"Closed"))


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2