Forum Discussion
Solved
Counting values from a multiple selection drop down list
Hi, I am trying to count how many times a value (a word) appears in a column, from a multiple dropdown list. In the above screenshot, "Neck" appears three times. If I use =COUNTIF(discomfo...
- Kindly use =COUNTIF(discomfort:discomfort), "*Neck*") and you will get the result.
Note - The asterisks (*) act as wildcards, allowing for any characters before or after "Neck" in the cell.
Kindly use =COUNTIF(discomfort:discomfort), "*Neck*") and you will get the result.
Note - The asterisks (*) act as wildcards, allowing for any characters before or after "Neck" in the cell.
Note - The asterisks (*) act as wildcards, allowing for any characters before or after "Neck" in the cell.