assign numbers a value, then get percentage
 

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.

assign numbers a value, then get percentage
 

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

"Lt. R" <Lt. wrote in message
...
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.