How to count one value or combo of values in a column of multiple values
Hi, we have a multi-select dropdown list column, where users chose one or more options. We want to count how many times a user chose an option (or combination of options), or did not choose a specified option. We can count all instances when one particular option was chosen using the following formula, but we cannot figure out how to include multiple terms or exclude terms.
=COUNTIFS([columnName]:[columnName], HAS(@cell, "optionName"))
We need help with 2 goals:
Goal 1: Formula that counts how many instances of specified option but only if it was the only choice
If we have five options (Option 1, Option 2, Option 2, Option 4, Option 5), we want to know how many people chose Option 1 *but did not choose any other option*, how many chose Option 2 *but did not choose any other option*, and so on. We are trying to isolate how many times a specified option was chosen as the only option.
Goal 2: Formula that counts how many instances of multiple specified options
We want to know how to count how many times a user chose a specified combination of options. In other words, when a user chose an Option AND another specified Option. For example, if a user chose Option 1 and Option 3, we want to count that. *We need to make sure we aren't accidentally counting all times Option 1 or Option 3 were chosen--only count the times when they are both chosen in the same cell.
Help Article Resources
Check out the Formula Handbook template!