Percentage formula?

Closed
Denise Cheffins
Posts
3
Registration date
Monday March 4, 2013
Status
Member
Last seen
March 5, 2013
- Mar 5, 2013 at 08:43 PM
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
- Mar 6, 2013 at 12:22 AM
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

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
770
Mar 5, 2013 at 11:27 PM
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
0
Denise Cheffins
Posts
3
Registration date
Monday March 4, 2013
Status
Member
Last seen
March 5, 2013

Mar 5, 2013 at 11:32 PM
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
0
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
770
Mar 6, 2013 at 12:22 AM
if all you have Yes, no and blank then use first one
0