Multiple Selections Drop Down List (used a VBA code) & CountIfs

I used a VBA code to allow me to select multiple items from a drop-down list in a particular column.

I have two other columns with other drop-down lists but not allowing for multiple selections.

I'm using COUNTIFS to count for certain parameters among the three columns in 3 x 2 columns for each parameter.

When I use COUNTIFS, excel doesn't count the parameters in the multiple selection drop-down list. It'll count only if I select one item but once I select more than one, it doesn't count any of the parameters.

How can I get excel to count what I want it to count?

Thanks.