=Countif(A:A,"Y")/(Countif(A:A,"Y")+Countif(A:A,"N"))

Adjustments for No should be obvious. This allows for entries other than
Yes or No such as a label. If only Yes (Y) or no (N) will apear in the
column

=Countif(A:A,"Y")/CountA(A:A)

in anycase, format the cell as percentage or multiply time 100.

Regards,
Tom Ogilvy

"Kim" wrote in message
...
I am trying to make a column with the cell showing a "Y"
for yes or a "N" for no. is there a formula that will
tell me what percentage is yes versus no? i have read
through the help section on this issue and still can't
figure this out. My boss wants me to get this resolved
and i am at the end of my rope. Please help.

Thanks,
Kim