% Selected Option in a column

Vinton Douglas

I am trying to create a formula to display % of selected option from a dropdown in a column. The options are:

1. I do not know
2. Yes, I heard about it
3. Yes, I read it

The column will be populated continuously, therefore 100 or more rows will be eventually populated.

From the column, how do I create a formula to represent % each of the option selected? I should therefore be able to ascertain, for example,

Screen Shot 2022-06-03 at 8.01.02 AM.png

75% of persons selected "Yes, I heard about it". See attached how the column will be represented.

Paul Newcome

You are going to need something like this...

=COUNTIFS([Dropdown Column Name]:[Dropdown Column Name], @cell = "Yes, I heard about it") / COUNT([Dropdown Column Name]:[Dropdown Column Name])

Paul Newcome

You are going to need something like this...

=COUNTIFS([Dropdown Column Name]:[Dropdown Column Name], @cell = "Yes, I heard about it") / COUNT([Dropdown Column Name]:[Dropdown Column Name])

Vinton Douglas

Works perfect! Thank you very much

Paul Newcome

Happy to help. 👍️