View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mike McLellan
 
Posts: n/a
Default Compound condition with COUNTIF

I want to be able to count values between 2 dates in a table. The query will
look something like:

=COUNTIF('Roll Out Schedule
23-Nov-05'!$H$3:$H$953,AND("27/11/05","<05/12/05"))

Can anyone tell me where I'm going wrong?