How to add cells with yes and no entries

  • Thread starter Thread starter jy
  • Start date Start date
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.
 
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.
 
Back
Top