COUNTIF excluding blank cells - (Cells have formulas)

[ACoombes]

I have a formula in column F (see Below) that provides me with a "yes", "no" or "blank" cell. I am trying to get the average number of “Yes” responses (excluding blank cells) in column F - formatted as a percentage with no decimal places (50%).
I am using the COUNTIF formula (see below) however, it is including the blank cell because there is a formula in there. I tried this on cells with no formula and it worked perfectly.
I need it to exclude the blank cells even though there is a formula in those cells.
HELP!!!

Column F Formula:
=IF(AND(OR(G3="x"),E3<=3),"Yes",(IF(AND(OR(H3="x"),E3<=7),"Yes",(IF(AND(OR(I3="x"),E3<=20),"Yes",IF(AND(ISBLANK(G3),ISBLANK(H3),ISBLANK(I3)),"","No"))))))

COUNTIF Formula:
=COUNTIF(F3:F52,"Yes")/(ROWS(F3:F52)-COUNTIF(F3:F52, "<>"&"*"))

 

[Jonmo1]

Welcome to the board.
Try counting the No's and Yes's, instead of Non Blanks..

=COUNTIF(F3:F52,"Yes")/SUM(COUNTIF(F3:F52,{"No","Yes"}))

 

[ACoombes]

Duh! Why didn't I think of that. I got so hung up on fixing the formula, I didn't think about changing what it says. Thank you so much!

 

[Jonmo1]

Glad to help, thans for the feedback.