One way:

=COUNTIF(A:A,"yes")/COUNTA(A:A)

format as a percent.

In article ,
joe wrote:

i have a column wiv loads of values either yes or no, i want to know the
percentage of yes's in the column