I have a golf scorecard with a cell for each hole that has
a yes or a no in it. The yes means that I hit that
fairway. The no means that I did not. I would like to be
able to have a cell that adds the total yes's and no's and
computes the percentage of fairways hit. Could someone
please let me know how I can do this or where I can go to
find the answer? Thanks for the help.

Same a when you first asked:


assume these boxes are in contiguous cells B3:B11

in another cell =countif($B$3:$B$11,"yes")/9 and format as percentage.

=countif($B$3:$B$11,"yes")/(countif($B$3:$B$11,"yes")+countif($B$3:$B$11,"ye
s"))

would be another

If that doesn't match yoursituation, then post back with specific details.



--
Regards,
Tom Ogilvy


"jy" wrote in message
...
I have a golf scorecard with a cell for each hole that has
a yes or a no in it. The yes means that I hit that
fairway. The no means that I did not. I would like to be
able to have a cell that adds the total yes's and no's and
computes the percentage of fairways hit. Could someone
please let me know how I can do this or where I can go to
find the answer? Thanks for the help.

-----Original Message-----
I have a golf scorecard with a cell for each hole that
has
a yes or a no in it. The yes means that I hit that
fairway. The no means that I did not. I would like to
be
able to have a cell that adds the total yes's and no's
and
computes the percentage of fairways hit. Could someone
please let me know how I can do this or where I can go to
find the answer? Thanks for the help.
.
Tom, I appreciate your response. I tried to enter the
formulas that you gave me and they did not work. The
first formula that you gave me continued to show a 0.0% in
the cell after I entered yes and no information in the
nine cells. The second formula left a #DIV/0 in the cell
after I entered yes and no information in the nine cells.
Can you tell me what I may be doing wrong. If it would
help to see the worksheet, I would be happy to send it to
you via e-mail if you would leave me your e-mail address.
My e-mail is . Thanks again for the help.