Percentage formula?
Closed
Denise Cheffins
rizvisa1
- Posts
- 3
- Registration date
- Monday March 4, 2013
- Status
- Member
- Last seen
- March 5, 2013
rizvisa1
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
2 replies
rizvisa1
Mar 5, 2013 at 11:27 PM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
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
Mar 5, 2013 at 11:32 PM
- 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
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
Mar 6, 2013 at 12:22 AM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Mar 6, 2013 at 12:22 AM
if all you have Yes, no and blank then use first one