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 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 6, 2013 at 12:22 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 6, 2013 at 12:22 AM
Related:
- Percentage formula?
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Date formula in excel dd/mm/yyyy - Guide
- Number to words in excel formula - Guide
- Excel grade formula - Guide
- Credit summation formula - Guide
2 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Mar 5, 2013 at 11:27 PM
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
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
Denise Cheffins
Posts
3
Registration date
Monday March 4, 2013
Status
Member
Last seen
March 5, 2013
Mar 5, 2013 at 11:32 PM
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
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
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Mar 6, 2013 at 12:22 AM
Mar 6, 2013 at 12:22 AM
if all you have Yes, no and blank then use first one
