assign numbers a value, then get percentage

[Lt. R]

I am trying to make a spreadsheet with Y as in yes, and N as in No. i want
to assign the Y and N a value, then get a total percentage of yes's at the
bottom. Once I have the spreadsheet populated by everyone all I have to do
is look at the bottom and see what percantage is in compliance based off of
the Y's entered in for each question.

 

[Bob Phillips]

=COUNTIF(A1:A100,"Y"),COUNTA(A1:A100)

and format the cell as a percentage.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)