help with percentage of yes or no's
 

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?

help with percentage of yes or no's
 

In . com,
spake thusly:

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

help with percentage of yes or no's
 

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.

" wrote:

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?

help with percentage of yes or no's
 

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.

" wrote:

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?

help with percentage of yes or no's
 

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?

" wrote:

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.

" wrote:

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?

help with percentage of yes or no's
 

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

"JLatham" wrote in message
...
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?

" wrote:

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.

" wrote:

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?

help with percentage of yes or no's
 

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

"Tom Ogilvy" wrote:

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

"JLatham" wrote in message
...
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?

" wrote:

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.

" wrote:

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?