We will use the COUNTIF function to sort the count. This isn’t limited to Yes or No, but any repeated value across a column. Eg. If you need to count the number of Yes and No entries for a list ...