Help with Formulas

  • Thread starter Thread starter Kim
  • Start date Start date
K

Kim

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
 
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
 
=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
 
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
 
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
 
Back
Top