Excel - COUNTIF & %

[evedawn]

Hi

Can you help? If I have 8 columns (say eg A2:H2) and 5 of these columns has a "Yes" answer whilst 3 have a "no" answer How do I work out the PERCENTAGE of Yes'?

I KNOW how to work out how many yes' via =COUNTIF(A2:H2,"Yes") the answer is clearly 5 but I need to thereafter add a way to work out the PERCENTAGE in the same formula. Is it possible?


Thanks in advance.

[ChuckFickens]

is it always 8 columms?

if so

=(COUNTIF(A2:H2,"Yes"))*12.5

[ChuckFickens]

And if its not always 8 columns then

=(COUNTIF(A2:H2,"yes"))/((COUNTIF(A2:H2,"no")
)+(COUNTIF(A2:H2,"yes")))*100


Should work for any range (there is probably a more elegant way to do it though)