Try this, Mark:
http://www.officearticles.com/excel/...ft_excel.h tm
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

"Mark G" <Mark wrote in message
...
Hi there. I have a long lists of data to sort though and I am trying to
write
a formula that counts that number of entries for a company with a certain
condition entered in another column. For instance

Company name Condition
Big Corp operatonal
Small corp operational
Big Corp non-operational

How do I count where Big Corp is operational and where it is
non-operational?

Thanks,
Mark