Count data based on dates

[jcammarata]

Hello,

I am trying to count how many times a value appears between a given date range.

So if I have 2 columns (A & B):


A
1/1/13
1/3/13
1/8/13
1/10/13
1/13/13
2/2/13

B
yes
yes
no
no
no
yes

I want to know how many times "no" came up between 1/1/2013 & 2/1/2013. I tried to use an IF statement which returns the correct value but it does not look in the other column to give me my results. Help! This seems like a simple LOOKUP formula but I cannot figure out how to do this. Using Excel 2003.

Thank you!

[benishiryo]

hi jcammarata. when you say between, i suppose you mean 2nd jan 2013 to 31 jan 2013? change the operators accordingly if i'm wrong.
=SUMPRODUCT((A2:A7>--"1jan2013")*(A2:A7<"1feb2013")*(B2:B7="no"))

[jcammarata]

I tried your formula but it returned the total for the year and not between the dates I want. My intention is to have individual cells with results for each month.

For example:
NO - > 1/1/13 - 2/1/13 = 3
NO - > 2/1/13 - 3/1/13 = 2
etc.

Maybe I am not understanding what your formula is doing so i am not sure what to change.

Thank you!

[jcammarata]

I found my mistake from your post. Your formula worked perfectly! Thank you!