Spreadsheet Page Excel Tips: Cell Counting Techniques

Excel provides many ways to count cells in a range that meet various criteria: ... To count the number of cells that contain the word "yes" (not case sensitive):

spreadsheetpage.com