#UNPARSEABLE using COUNTIF for text objects

I have a Form which allows the recipient to answer a question via a drop down list:

Example: Where would you like to go for vacation?

List includes: U.S., Europe, Asia, Australia

It's a pick many list so users can select any number of answers. The resulting cell then may contain something like: U.S. Europe Asia

I would like to create a COUNTIF for each of the possible contents so the end result looks like:


U.S. 7

Europe 16

Asia 24

Australia 8

My formula looks like this:

=COUNTIF([Destination], CONTAINS(U.S.)

What am I missing here?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!