See one answer in the .misc newsgroup.

Please don't post the same question to multiple groups. At best it tends
to fragment any answers you get, and it potentially wastes the time of
those answering questions that have already been answered.

For tips on using these groups effectively, see

http://cpearson.com/excel/newposte.htm

In article ,
joemoran7 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

e.g. if there were 20 yes's in the column and 20 no's then the
percentage of yes's would be 50%