Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with Formulas
I am trying to make a column with the cell showing a "Y"
for yes or a "N" for no. is there a formula that will tell me what percentage is yes versus no? i have read through the help section on this issue and still can't figure this out. My boss wants me to get this resolved and i am at the end of my rope. Please help. Thanks, Kim |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with Formulas
Kim You need to use countif. If the column you are looking at is, say, C1 to C100, then use the following: =countif(C1:C100,"Y")/counta(C1:C100) Format this as a percentage and this will give you the percentage of Y's. Change the "Y" to a "N" for N's. Andy *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with Formulas
=Countif(A:A,"Y")/(Countif(A:A,"Y")+Countif(A:A,"N"))
Adjustments for No should be obvious. This allows for entries other than Yes or No such as a label. If only Yes (Y) or no (N) will apear in the column =Countif(A:A,"Y")/CountA(A:A) in anycase, format the cell as percentage or multiply time 100. Regards, Tom Ogilvy "Kim" wrote in message ... I am trying to make a column with the cell showing a "Y" for yes or a "N" for no. is there a formula that will tell me what percentage is yes versus no? i have read through the help section on this issue and still can't figure this out. My boss wants me to get this resolved and i am at the end of my rope. Please help. Thanks, Kim |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with Formulas
OK, i have put the formula in that you gave me, changing
the row and column numbers accordingly, now, how do i get the formula to actually calculate? i am not very familiar with using excel except for data entry. Thanks again, Kim -----Original Message----- I am trying to make a column with the cell showing a "Y" for yes or a "N" for no. is there a formula that will tell me what percentage is yes versus no? i have read through the help section on this issue and still can't figure this out. My boss wants me to get this resolved and i am at the end of my rope. Please help. Thanks, Kim . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with Formulas
A couple of possibilities
What do you see - do you see the formula you just entered? if so, is the very first character of the formula and equal sign as shown if it is, is the cell formatted as text? If so, format the cell as general, select the cell, hit F2, then enter If you still see the formula, go into tools=Options and select the View tab, make sure Formulas is unchecked at the bottom area (Windows Options). do Ctrl+Alt+F9 - does it calculate? If so, then perhaps you have calculation set to Manual Tools=Options=Calculation tab and click on Automatic Other than that, it should calculate when you enter it. However, you have to change the formulas offered so they point to the actual location of your data (where the Y's and N's are). Mine pointed to column A and Andy's pointed to Cells C1 to C100. Regards, Tom Ogilvy "Kim" wrote in message ... OK, i have put the formula in that you gave me, changing the row and column numbers accordingly, now, how do i get the formula to actually calculate? i am not very familiar with using excel except for data entry. Thanks again, Kim -----Original Message----- I am trying to make a column with the cell showing a "Y" for yes or a "N" for no. is there a formula that will tell me what percentage is yes versus no? i have read through the help section on this issue and still can't figure this out. My boss wants me to get this resolved and i am at the end of my rope. Please help. Thanks, Kim . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert Array Formulas to Regular Formulas | Excel Worksheet Functions | |||
E2007 formulas display as formulas, not results | Excel Worksheet Functions | |||
Counting # of Formulas in a column with formulas and entered data | Excel Worksheet Functions | |||
CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
Formulas not evaluated, Formulas treated as strings | Excel Discussion (Misc queries) |