help with percentage of yes or no's

[sschadel]

I have a spread sheet where a question is answered with a yes or no how
do i convert that into a percentage for the entire row?

a1 complete?
a2 yes
a3 no
a4 no
a5 no
a6 percent complete
a7 25%

does this make sense?

 

[Dallman Ross]

In <[email protected]>,

I have a spread sheet where a question is answered with a yes or
no how do i convert that into a percentage for the entire row?

a1 complete?
a2 yes
a3 no
a4 no
a5 no
a6 percent complete
a7 25%

Here's one way for A7:

=COUNTIF(A2:A5,"yes")/COUNTIF(A2:A5,"*")

Format A7 as type "percent."

Dallman

 

[JLatham]

In A7:
=COUNTIF(A2:A5,"Yes")/ROWS(A2:A5)
that's one of several ways to do it,
the COUNTIF() is the way to count "Yes" entries in the range, while ROWS()
will give you a total count of the range whether they are Yes, No or empty.

 

[sschadel]

wow thank you i really did not expect anyone to take the time to help.
at least not that fast! it worked perfectly
thanks again..

 

[JLatham]

Glad to have helped, Dallman's solution would have worked also.

If you find help offered here actually helpful, people really appreciate you
giving feed back using the [yes][no] buttons on their postings?

 

[Tom Ogilvy]

Since sschadel didn't post in the microsoft communities I am sure he has no
idea what your are talking about with respect to yes and no buttons. This
should be visible to you in the communities interface.

--
regards,
Tom Ogilvy

Glad to have helped, Dallman's solution would have worked also.

If you find help offered here actually helpful, people really appreciate
you
giving feed back using the [yes][no] buttons on their postings?

wow thank you i really did not expect anyone to take the time to help.
at least not that fast! it worked perfectly
thanks again..

 

[JLatham]

My lack of attention to detail showing again!

And apologies to sschadel if I seemed rude. Did not mean to be. The thanks
he gave was sufficient, I just kind of figure is someone sees the green check
here at the Microsoft place, then they can pass it by and help another
deserving soul.

I'll try to pay more attention in the future. And again, sincere apologies
to sschadel.

JLatham

Since sschadel didn't post in the microsoft communities I am sure he has no
idea what your are talking about with respect to yes and no buttons. This
should be visible to you in the communities interface.

--
regards,
Tom Ogilvy

Glad to have helped, Dallman's solution would have worked also.

If you find help offered here actually helpful, people really appreciate
you
giving feed back using the [yes][no] buttons on their postings?

wow thank you i really did not expect anyone to take the time to help.
at least not that fast! it worked perfectly
thanks again..
JLatham wrote:
In A7:
=COUNTIF(A2:A5,"Yes")/ROWS(A2:A5)
that's one of several ways to do it,
the COUNTIF() is the way to count "Yes" entries in the range, while
ROWS()
will give you a total count of the range whether they are Yes, No or
empty.

:

I have a spread sheet where a question is answered with a yes or no
how
do i convert that into a percentage for the entire row?

a1 complete?
a2 yes
a3 no
a4 no
a5 no
a6 percent complete
a7 25%

does this make sense?