Drop down multiselect column - getting count data

Matt Pittman

I have set up a form with a multi select list and I need to be able to tally the selections against each of the items. I have looked on here a lot and tried various versions of COUNTIF and COUNTIFS and COUNTM and have exported to Excel and tried to do it that way and cannot figure out what to do.

Can someone point me to the correct syntax for this? Image is of the field responses.

Paul Newcome

Try this...

=COUNTIFS([Multi-Select]:[Multi-Select], HAS(@cell, "insert specific text here"))

Paul Newcome

Try this...

=COUNTIFS([Multi-Select]:[Multi-Select], HAS(@cell, "insert specific text here"))

Matt Pittman

That did it! Thank you so much!

Paul Newcome

Happy to help. 👍️