Count number of "Yes" between two dates

[Sophie]

How can I Count number of "Yes" between two dates.
Date col=A
Yes col=E

Thanks

 

[Elkar]

Try this:

=SUMPRODUCT(--(A1:A10>=DATE(2009,2,1)),--(A1:A10<=DATE(2009,2,28)),--(B1:B10="Yes"))

This would count the number of times "Yes" appears in Column B when the date
in column A is in Feb 2009.

HTH
Elkar

 

[Raz]

=COUNTIF(E:E,"Yes")
OR
=COUNTIF(E1:E100,"Yes")

 

[Shane Devenshire]

Hi,

You can't do this with COUNTIF because there are three conditions. If you
are using 2007 you can use

=COUNTIFS(A1:A10,">="&D1,A1:A10,"<="&E1,B1:B10,"Yes")

In this example D1 and E1 contain the dates you are looking between.

 

[Sophie]

It works when I insert "No" but not with "Yes"