Please help me. I am trying to create a function that will count if cell
values are between 60 and 180.

The funtion below works but I can't get the AND logic in the function.

=COUNTIF(AE740:AE863,"180")

I have tried this but it does not work: =COUNTIF(AE740:AE863,"60 AND <180")
I have also tried this: =COUNTIF((AE740:AE863,"60) AND (AE740:AE863, "<180"))


Thanks, Misty

--
Message posted via http://www.officekb.com