Percentage formula?

[Closed]
Report
Posts
3
Registration date
Monday March 4, 2013
Status
Member
Last seen
March 5, 2013
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,


I have a column in a Micosoft Excel spreadsheet that contains Yes & No answers.
Can anyone please tell me how do I find out how many Yes answers I have compared as a percentage, to the total number of Yes & No answers in the column.
Is this done via a chart, pivot table or a formula at the bottom of the column and how?
Any help is much appreicated.

Many thanks

2 replies

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
If you only have YES and NO
then
=COUNTIF(A:A,"NO")/COUNTA(A:A)


if you have YES, NO and some other text then
=COUNTIF(A:A,"NO")/(COUNTIF(A:A,"NO") + COUNTIF(A:A,"YES"))

Format as Percentage
Posts
3
Registration date
Monday March 4, 2013
Status
Member
Last seen
March 5, 2013

Thanks for this I have not had a lot to do with forumlas in excel except for the basic ones.
And yes there are blanks in the column as well as yes or no answers.
I will give it a go as soon as I can and let you know how I go.

Again many thanks
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
if all you have Yes, no and blank then use first one