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:
[RESULTS] [COUNT]
U.S. 7
Europe 16
Asia 24
Australia 8
My formula looks like this:
=COUNTIF([Destination], CONTAINS(U.S.)
What am I missing here?
