Percentage formula?
Closed
Denise Cheffins
Posts
3
Registration date
Monday 4 March 2013
Status
Member
Last seen
5 March 2013
-
5 Mar 2013 à 20:43
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 6 Mar 2013 à 00:22
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 6 Mar 2013 à 00:22
Related:
- Percentage formula?
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Spreadsheet formula - Guide
- Grade formula in excel marksheet - Guide
- Credit summation formula - Guide
- Formula bar in excel - Guide
2 responses
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
5 Mar 2013 à 23:27
5 Mar 2013 à 23:27
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 4 March 2013
Status
Member
Last seen
5 March 2013
5 Mar 2013 à 23:32
5 Mar 2013 à 23:32
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 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
6 Mar 2013 à 00:22
6 Mar 2013 à 00:22
if all you have Yes, no and blank then use first one
