#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:
My formula looks like this:
What am I missing here?
Help Article Resources
Check out the Formula Handbook template!