locked
Percentages from Numerical Values Assigned to Text RRS feed

  • Question

  • I am new to Excel and am having trouble with what I thought would be a simple formula.  I am trying to create a formula that will find the percentage of text in a single column.  Example, I am looking for the percentage of "Yes" to "No" values in a column, and am not sure if I should assign a numerical value and then try and create a formula that will calculate the percentage. I have had no luck so far, any help would be much appreciated.

    Friday, June 20, 2014 2:25 PM

Answers

  • Assuming the yes/no values are in column A, the following formula with give the percentage of 'yes' entries in that column:

    =COUNTIF(A:A,"yes")/COUNTA(A:A)*100

    If you format the result as %, omit the *100.


    Cheers
    Paul Edstein
    [MS MVP - Word]

    • Marked as answer by George123345 Monday, June 30, 2014 6:52 AM
    Saturday, June 21, 2014 4:58 AM