Compound condition with COUNTIF

M

Mike McLellan

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?
 
B

Bob Phillips

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



--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top