Sumproduct with Date as a field 1

[dr772]

HI,
I have a table see below. I need to count how many times "4 Monti" occurs in Jan.
If column A was just "Jan" I understand how to do it but how do I do it with the dates in this format....please help...

A B
1/16/06 2 cohen
1/12/06 4 Monti
1/6/06 4 monti
5/12/06 ccu
5/5/06 2 cohen
4/5/06 4 monti

 

[AnotherHiggins]

Here ya go:
[COLOR=blue white]=SUMPRODUCT((A1:A6>VALUE("12/31/05")) * (A1:A6<VALUE("02/01/06")) * (B1:B6="4 Monti"))[/color]

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.

 

[dr772]

Thanks....you have helped me again...

 

[AnotherHiggins]

Glad to help!


[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.