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?