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