Count of dropdown options (like you can with a pivot table?)
I've created a quick Form to help my HR team collect votes from staff on 4 key areas. I've used the "Dropdown (multi select)" column type, and the Form asks staff to select the 2 options they rank as most important from these lists.
Is there an easy way to then see how many votes have been allocated to each option? Through a dashboard, or using formulas..?
For example:
Area 1, Option 1: 2 votes
Area 1, Option 2: 7 votes
Best Answer

It is actually pretty straight forward. You would use a basic COUNTIFS function for this.
You would first set up your pivot table (column headers in bold).
Option (Table)....................................Count
Option 1..................................................f
Option 2.................................................f
Your formula would then look something like this...
=COUNTIFS([Dropdown Column]:[Dropdown Column], CONTAINS([Option (Table)]@row, @cell))
Answers

It is actually pretty straight forward. You would use a basic COUNTIFS function for this.
You would first set up your pivot table (column headers in bold).
Option (Table)....................................Count
Option 1..................................................f
Option 2.................................................f
Your formula would then look something like this...
=COUNTIFS([Dropdown Column]:[Dropdown Column], CONTAINS([Option (Table)]@row, @cell))

Thanks Paul  I was overthinking it, of course! This is perfect.

Happy to help! 👍️
Help Article Resources
Categories
Check out the Formula Handbook template!