=SUMPRODUCT(--(YEAR(A2:A20)=2007),--(MONTH(A2:A20)=1))

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"naz" wrote in message
...
Im trying to count the number of entries for every month from a list of
cells.
I've got the basic count if function but how do i tell it to count every
entry for jan 07?
Should i no be using countif?

Thanks