One way:

=SUMPRODUCT(--(A2:A100="John"),--(B2:B100=1),--(MONTH(C2:C100)=1),
--(YEAR(C2:C100)=2008))

In article ,
Astro wrote:

Currently I'm encounting error for SUMPRODUCT formula:

Name Judgement Date
John 1 Jan-08
Sarah 1 Jan-08
John 1 Feb-08
John 0 Jan-08
John 1 Jan-08

What formula can I use so that the count will be 2 for name "John",
judgement "1", month "Jan" & year "2008"?

Please help.... Thank you.