Thread: Counting items with a specific quanitifier in a date range
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default Counting items with a specific quanitifier in a date range
=SUMPRODUCT(--(TEXT(A2:A5,"mmm-yy")="Nov-08"),--(B2:B5="SP"))


"sprillaman" wrote:

I have 2 columns:
Date Person
10/31/08 SP
11/01/08 JS
11/15/08 SS
11/18/08 SP

I need to count the number of occurances of the person within a specific
date range. More specifically, how many times did SP occur during the month
of November? I have tried with Countif and Sumproduct formulas and can't
seem to get it right. Any help would be greatly apprciated.
Reply With QuoteReply With Quote