I think the formula below should do the trick for you counting issue.
In the formula, you need to change the following:

A2:a20 is your range of dates
G8 is the range where you would enter FEB
B2:b20 is the range that would have New in it

=SUMPRODUCT((TEXT($A$2:$A$20,"MMM")=G8)*($B$2:$B$2 0="New"))

Let me know if you have any problems with this - I tested it quickly
and it seemed to work. Later - Chad


--
cvolkert
------------------------------------------------------------------------
cvolkert's Profile: http://www.excelforum.com/member.php...o&userid=24380
View this thread: http://www.excelforum.com/showthread...hreadid=514643