Countif question

  • Thread starter Thread starter patricia
  • Start date Start date
P

patricia

Is it possible to use "and" in the countif formula
I want to do =COUNTIF(F58:F68,">=06/17/04 and <= 06/25/04")
and cannot get it to work correctly

Thanks
 
You could combine two of them in this way:

=COUNTIF(F58:F68,">=06/17/04")-COUNTIF(F58:F68,">06/25/04")


--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================





Is it possible to use "and" in the countif formula
I want to do =COUNTIF(F58:F68,">=06/17/04 and <= 06/25/04")
and cannot get it to work correctly

Thanks
 
Back
Top