Thread
:
assign numbers a value, then get percentage
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips
Posts: n/a
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.
Reply With Quote