Hi,

Try this. "Sometext" is the String your looking for in column B

=SUMPRODUCT((TEXT(A1:A1000,"mmyy")=TEXT(C2,"mmyy") )*(B1:B1000="Sometext"))


Mike

"Mona" wrote:

I have daily dates (mm/dd/yyyy) in colA and text in colB. In cell C2 I have
03/2008 (mm/yy). I need a formula : count colB when A:A=C2. Thanks! -Mona