Column B shows the answers to the question numbers displayed in column A.
An auto-filter is set for both columns.
We want to create a formula that will count the number of times each possible answer (listed in cells A26:A29) occurs for each of the filtered question numbers.


Use the SUMPRODUCT, SUBTOTAL, OFFSET, ROW, and MIN functions as shown in the following formula:
Enter the above formula next to the 4 possible answers (cells B26:B29).