Kim

You need to use countif. If the column you are looking at is, say, C1
to C100, then use the following:

=countif(C1:C100,"Y")/counta(C1:C100)

Format this as a percentage and this will give you the percentage of
Y's. Change the "Y" to a "N" for N's.

Andy


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!