Countif question

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
 
R

RagDyeR

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

countifs Function not giving desired result with date criteria 2
Finding the weighted average of text that have been given values 1
time_report_date-wise_employee-wise 6
count not-overlapping days in a "Table" with Beginning and EndingsDates Specified 0
Using <= in countifs statement 1
Function help 7
COUNTIF with 2 columns 2
countifs Text and Dates 7

Top