Counting items with a specific quanitifier in a date range

S

sprillaman

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.
 
S

Shane Devenshire

Hi,

Try something like

=SUMPRODUCT(--(A1:A10>=D1),--(A1:A10<=D2),--(B1:B10=D3))

Where 11/1/08 is in D1, 11/30/08 is in D2 and a name is in D3
 
R

Rick Rothstein

Try this...

=SUMPRODUCT((MONTH(A2:A1000)=11)*(B2:B1000="SP"))

Note: This doesn't restrict the search to only Novembers in 2008.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

count not-overlapping days in a "Table" with Beginning and EndingsDates Specified 0
Allocate an income payment over a date range (tax years) 7
Sumproduct or Countif - Counting Occurances within a Date Range 2
Help Please calculating date range - Other posts didn't help 6
Counting number of rows between date range and meeting 2 string criteria 11
When building a chart Dates are been included that are not in thedate range 2
counting items within a date range 1
counting the occurances for specific dept within a given time peri 1

Top