| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to Count the number of "rows" (or Array items) included in a Sumif formula? | Excel Discussion (Misc queries) | |||
| Formula to count number of time stamps within a range in a column having dates formatted as "custom" | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
| Count the number of Lines in a "wrap text"-cell | Excel Discussion (Misc queries) | |||
| How do I count like dates in a column with format "January-05"? | Excel Worksheet Functions | |||
Linear Mode
