S
Sophie
How can I Count number of "Yes" between two dates.
Date col=A
Yes col=E
Thanks
Date col=A
Yes col=E
Thanks
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
E
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
=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
R
Raz
=COUNTIF(E:E,"Yes")
OR
=COUNTIF(E1:E100,"Yes")
OR
=COUNTIF(E1:E100,"Yes")
S
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.
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.
S
Sophie
It works when I insert "No" but not with "Yes"