=COUNTIF(Q3:Q63,"Meets Requirement")/COUNTA(Q3:Q63)

I am using the formula above but now in some columns I have blank fields and some fields with 0 and some with "None requirement competence" I would like the formula to ignore all of those fields

Please help!