Morning All,

I need assistance with adding a condition to my "month counting" formula. I currently have two formulas that work (see below). I would like for the formula to only count months that have a status other than closed. Any ideas? Feel free to create a new formula if need be.


Example:
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.


SUMPRODUCT(--($A$1:A$251<""),--(MONTH($A$1:A$251)=1))
SUMPRODUCT((TEXT($A$1:$A$1999,"mm")="01")+0,($A$1: $A$1999<"")+0)

Thanks in advance
Tee