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