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.

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


--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


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

Try this...

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

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

--
Rick (MVP - Excel)


"sprillaman" wrote in message
...
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.

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