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.

=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. [email protected]> wrote in message
news:[email protected]...
> 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.