Hi Michael

With date in Column A and Result in B
=SUMPRODUCT(--(MONTH($A$2:$A$1000)=1),--($A$2:$A$1000<""),
--($B$2:$B$1000="Repudiated"))

--
Regards
Roger Govier

"Michael B" wrote in message
...
Hi all,

I have gone through all the previous posts and tried several different
variations but still can`t get it. Can anyone help?

I have 2 columns, one has a date in (the date closed) and the other has
either "Repudiated" or "Withdrawn" in.
I need to count the amount of entries in January that have been
"Repudiated"

Any ideas please..

Many Thanks

Michael.