No need to use filters, sort, scroll, count and repeat. The magic formula is: COUNTIF Let’s say your categories are in column D (from row 2 to 112). And you want to count how many people said ...