Count number of "Yes" between two dates
 

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

Thanks
--
Sophie

Count number of "Yes" between two dates
 

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


"Sophie" wrote:

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

Thanks
--
Sophie

Count number of "Yes" between two dates
 

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



"Sophie" wrote:

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

Thanks
--
Sophie

Count number of "Yes" between two dates
 

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,"Ye s")

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

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Raz" wrote:

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



"Sophie" wrote:

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

Thanks
--
Sophie

Count number of "Yes" between two dates
 

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


"Shane Devenshire" wrote:

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,"Ye s")

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

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Raz" wrote:

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



"Sophie" wrote:

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

Thanks
--
Sophie