Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
Increasing numbers in a column by percentage | Excel Worksheet Functions | |||
How do I assign sequential numbers in an invoice? | New Users to Excel | |||
DECREASE ALL NUMBERS IN A COLUMN BY A PERCENTAGE | Excel Worksheet Functions | |||
Sorting when some numbers have a text suffix | Excel Discussion (Misc queries) |