Looking for Yes and No answer percentages
I have a sheet with 4 columns that are yes and no answers. I am looking to get percentages for each answer in each column. I would also like to put this is a summary field so I can extract it to a dashboard. I'm struggling to find the right formula for this, and was hoping someone could help.
Best Answer

Hi @jmdierking,
I would try this formula in your Sheet Summary to capture the % for Yes:
=COUNTIF([Column1]:[Column1], "Yes") / COUNTIF([Column1]:[Column1], OR(@cell = "Yes", @cell = "No"))
I would use this formula to capture the percentage for No:
=COUNTIF([Column1]:[Column1], "No") / COUNTIF([Column1]:[Column1], OR(@cell = "Yes", @cell = "No"))
After you apply the formulas to your Sheet Summary fields, you will need to change the fields to be formatted as Percentage. To do that, click the 3 dots next to the Summary field name, select "Number Formatting", and then select "Percentage".
Hope this helps!
Ray
Answers

Hi @jmdierking,
I would try this formula in your Sheet Summary to capture the % for Yes:
=COUNTIF([Column1]:[Column1], "Yes") / COUNTIF([Column1]:[Column1], OR(@cell = "Yes", @cell = "No"))
I would use this formula to capture the percentage for No:
=COUNTIF([Column1]:[Column1], "No") / COUNTIF([Column1]:[Column1], OR(@cell = "Yes", @cell = "No"))
After you apply the formulas to your Sheet Summary fields, you will need to change the fields to be formatted as Percentage. To do that, click the 3 dots next to the Summary field name, select "Number Formatting", and then select "Percentage".
Hope this helps!
Ray

My method above will also ignore any blanks because it's strictly looking for Yes or No values.

This was exactly what I was looking to do!! Thank you!!

Awesome, glad it worked! Please remember to smash that Answer button, so others can more easily find solutions like this!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 10.5K Get Help
 61 Global Discussions
 46 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 54 Brandfolder
 124 Just for fun
 50 Community Job Board
 466 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!