Hi

It's working absolutely fine here. No clue why this isn't working at your end
I have tested this in both xl 2003 and 2007. BTW, I have changed the formula little bit so that it would take care of the year and month

lngCount = Evaluate("sumproduct(--(text(" & ETS_Col & ",""mmyy"")=text(""" & Jun & """+0,""mmyy"")),--(" & Pol_Col & "=""" & HK & """),--(" & PoD_Col & "=""" & KT & """))")

change the bold part in other two formulas as well.

For the next 10 days, I'll have limited access of net. So I might not able to answer your queries in time.