john3j
03-19-2009, 08:30 AM
Hey guys, I am trying to count some stuff. I have the Month of October in A8 and in B8 I would like to count the number of of instances where the following criteria are met:
E29:E1000="Yes"
F29:F1000 equals any date in the month of 10/2008
I guess if I was just gonna write something logically I would put:
B8 =COUNTIF((E29:E1000, "Yes"),F29:F1000, Between 10/1/2008 and 10/31/2008))
I just dont know how to do the date part. I would appreciate the help. Thanks!
E29:E1000="Yes"
F29:F1000 equals any date in the month of 10/2008
I guess if I was just gonna write something logically I would put:
B8 =COUNTIF((E29:E1000, "Yes"),F29:F1000, Between 10/1/2008 and 10/31/2008))
I just dont know how to do the date part. I would appreciate the help. Thanks!