yup it was the format..many thanks

"Bob Phillips" wrote:

Works fine for me naz. Are the cells formatted as text? Is there an error in
one of the cells?

--
HTH

Bob

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

"naz" wrote in message
...
Thanks bob but i cant get it to work im getting the #value! error and i
dont
understand why...heres what im working with...

Date requested
01/01/07
02/01/07
01/02/07
02/02/07
31/12/06

raised in jan07 =
raised in feb 07 =

"Bob Phillips" wrote:

=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