How to count answers in a dropdown column

MindyM

Hello - I have a survey I created via a form and one of the questions is a dropdown menu where people can select 3 topics they'd like to learn more about. Is there an easy way to count how many times people selected each topic? We want to see what the top topics people want to learn more about are.

Thank you for the assistance!

Jeff Reisman

@MindyM

You can use COUNTIF with the HAS function.

=COUNTIF([3 Topics would like more info]:[3 Topics would like more info], HAS(@cell, "Value you want to count"))

This will count the number of cells in the column that contain the value you want to count.

Example:

MindyM

Thank you so much! I was on the right track using the COUNTIF formula but I didn't know about the HAS feature. That worked perfectly! :)

Jeff Reisman

https://community.smartsheet.com/discussion/comment/415489#Comment_415489

Awesome, glad to help. I like the HAS function, it's like a sooped-up version of CONTAINS. Once I figured out how the HAS function works, I rewrote part of the help page for it because it used to be just a hastily rewritten copy of the CONTAINS help page and described the functionality wrong. (The example grid at the bottom of the HAS page is still wrong though!)