To count yes or no in google sheets, use the COUNTIF formula. Here is the formula for counting yes or no in column E: =COUNTIF(E1:E20,"yes") Since yes or no are not boolean values, you need to treat them as strings or text values while writing the COUNTIF formula.