I am trying to count how many times a word is picked in multi dropdown menu

Caolan Kelly

So i have a single column with a multi drop down box. The reason for this is to select multiple options in certain circumstances. When i use =COUNTIF(Classification:Classification, "text") it will count if only one option is picked but once more than one of the selections is picked it will only count 1 of the 2.

when i use =contains it comes back as not possible.

for example ;

if i have multiple names down one row and in the next a multiselect dropbox of favourite colours and people can choose more than one, what formula will allow me to pick every time red is picked in that column ?

TIA

Mary Royston

Hey @Caolan Kelly,

You should be able to use =countif([Classification]:[Classification], contains("red", @cell))

Let me know if that works, if not we can always try a different solution :)

Mary Royston

Hey @Caolan Kelly,

You should be able to use =countif([Classification]:[Classification], contains("red", @cell))

Let me know if that works, if not we can always try a different solution :)

Caolan Kelly

Thank you so much for the help, i had tried this so many times but when i copied yours in it seems to work.