View Single Post
  #1   Report Post  
Shannon
 
Posts: n/a
Default COUNTIF With Multiple Dates, Columns and Text

I need to count a number of entries that are between two dates where that
data is stored in column A and also if the text value in column F is "yes".
I have a formula to count the entries between two dates and a formula to
count the entries for the text equal to "yes", but I cannot bring it together
to do both...any suggestions?

=COUNTIF('Student Listing'!$A$2:$A$300,"=10/1/04")-COUNTIF('Student
Listing'!$A$2:$A$300,"=10/31/04")

=COUNTIF('Student Listing'!$F$2:$F$300,"Yes")

Thanks!