Count of dropdown options (like you can with a pivot table?)

Amy Buckle

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

Paul Newcome

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))

Paul Newcome

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))

Amy Buckle

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

Paul Newcome

Happy to help! 👍️