I have a code on one column and a drop list with 11 options in another column. Is there a way to when the code is used and one or any of 11 options selected from the drop down list to be counted as 1 so effectively group the 11 eleven options and count them as 1 when selected.
I am trying to get excel to count 11 text strings/options as 1 not 11. Can this be done using countif function?
will using 11 if statements work?
I have tried to show this in the attached picture, unfortunately I can not upload workbooks!
I hope this makes sense!
Many thanks.
Bookmarks