What am I doing wrong with this COUNTIF formula?

[AndyFox42]

I am trying to organize some data, and calculate what percentage of the time the answer is "Yes." The data consist of either Yes, No, or N/A. I want to see what percentage of responses are Yes, but exclude the N/A's from the denominator. This is the formula I am using:

=COUNTIF(O5:O26, "Yes") / COUNTIF(O5:O26, "Yes"+"No")

I am getting a #DIV/0! error. Is there an alternate way to do this, so my percentage is not rendered inaccurate because the N/A's are factored in when calculating how many entries are "Yes?"

[TMS]

One way:

=COUNTIF(O5:O26, "Yes") / (COUNTIF(O5:O26, "Yes") + COUNTIF(O5:O26, "No"))


Regards, TMS

[AndyFox42]

Perfect! Thanks!