Previous Topic Next Topic

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

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