assign numbers a value, then get percentage

L

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.
 
B

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)
 
Top