How to add cells with yes and no entries

[jy]

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 Ogilvy]

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.

 

[JY]

-----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 (e-mail address removed). Thanks again for the help.