View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Astro Astro is offline
external usenet poster
 
Posts: 9
Default Help in SUMPRODUCT formula...

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.