Excel – Count text values

It is easy to sum or count a group of numbers in Excel. What is harder is summing or counting a group of words. For example, let’s say you have a column of data that contains “Yes” and “No” and you want to count the number of “No’s”