Count multi select dropdown

Autumn Bennett

Hi there, could anyone assist with a formula that would count a multi select dropdown and show all selections? I was using below but it seems like its only counting top option even though say 3 options may be checked, I would like the total to be in each category? Thanks!

=COUNTIF({Sheet - Sales Pipeline Range 5}, Labels@row)

John Jonassen

Try something like this:

=COUNTIF({Sheet - Sales Pipeline Range 5}, CONTAINS(Labels@row, @cell))

John Jonassen

Try something like this:

=COUNTIF({Sheet - Sales Pipeline Range 5}, CONTAINS(Labels@row, @cell))

Autumn Bennett

yup, perfect! Thanks so much