How to add cells with yes and no entries

J

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.
 
T

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Yes/No Button 1
Query of checkboxes. 5
formula with yes and no 6
Create Pop-Up quiz Window with yes no questions 0
Help creating golf statistic form 4
4 cells with yes, no list 1
Formulas 2
Delete multiple pictures on top of a range? 1

Top