COUNTIFS Function for Multiple Data in the Same Cell

Afternoon all, it's nice to have joined this community. I begin with a problem:

Screen Shot 2018-07-31 at 13.42.25.png

So I am programming an interactive database for the company I am interning at for data collection on people/demographics etc.

I have added a selection list data validation in a few columns for data input, as you can see above, and I added a VBA macro to allow multiple selections from the list specifically for impairments (disabilities) which are separated by commas. However, I am using the 'COUNTIFS' function to report the data by number of people of that particular impairment to assess achievement rates, but obviously with multiple inputs the cell no longer "=Hearing" (for example), so the COUNTIFS function does not count them:

Screen Shot 2018-07-31 at 13.48.51.png

My question: How do I adjust the formula such that it looks for cells containing the word "Hearing" (for example) in that range, rather than looking for cells that are equal to "Hearing"?

Thanks in advance, will certainly have more questions to come.