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.
=COUNTIF(discomfort,"*neck*") would work, provided that the list of discomforts is in a named range called 'discomfort'.
The asterisks are wild-cards and tell Excel to look for anything with the text "neck" in it. Not necessarily and exact match for the whole text in a cell. That's why "wrists" worked as it had no other text with it.
- Thank you so much. This has worked 🙂
