=COUNTIF(AE740:AE863,"60")-COUNTIF(AE740:AE863,"180")

you might want to change the second to = if you want to exclude 180.



--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Mitchell_Collen via OfficeKB.com" <u33726@uwe wrote in message
news:73effad7f72b7@uwe...
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