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?