Thanks for your help... it worked great

"Bob Phillips" wrote:

=COUNTIF(G:G,"y")/COUNTA(G:G)

and format as a percentage

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"NKDodd" wrote in message
...
I have a column that we either enter "y" for yes or "n" for no to track
passing scores. Is there a way that I can average the yes' and no's from
the
same column?