An accurate answer was given in your first posting of this question. If you
write the formula correctly, this is the way it is done. countif does not
work with the AND/OR functions for criteria.

suggestion was tested and worked fine.

--
Regards,
Tom Ogilvy

"brianwakin" wrote in message
...
I need to And /Or with the countif function. How do I do this?
--
Brian