calculating percentage of specified text responses

[seshultz]

Hello,
I have created a worksheet and used Data Validation to allow only a specified list of responses. I now want to calculate the percentage of total entries that have one of the specified responses.

For example, in one of my columns I have specified the List Sources to be Yes or No. As data is entered and responses are chosen either Yes or No, I want the calculation of % of total entries that the response is Yes at the bottom of the column.

I used the formula =COUNTIF(G3:G39,"Yes") which counts the entries which have been answered "Yes" but I would like to compare the counted number the total number of entries so I can easily see if the number counted is 5 yeses out of 5 entries, or 5 yeses out of 500 entries, so I think I need to include a reference to the total number of non-blank entries in that column in order to get the denominator. Am I on the right track?

Thanks in advance!

[Pepe Le Mokko]

Have a look at the COUNTA function

[Richard Buttrey]

Yes indeed. just extend your formula as below

=COUNTIF(G3:G39,"Yes")/COUNTA(G3:G39)

[seshultz]

Thank you very much Richard and Pepe!

Worked perfectly!

Sarah