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?