ok so for example on my spreadsheet there is number 5 and a drop down list to say where number 5 should go. There are more than 11 options in this drop down list. I need to count when 5 appears in the spreadsheet, how many times these 11 options were selected and count them as being 1 as opposed to counting them individually. In other words grouping these 11 options (in the attached pic they are test1-test11) and counting them as 1.
I hope this helps.
Bookmarks