Getting Percent values from text

[Codith]

Hey guys need some help on a problem.


I'm trying to do some percentage values on text and I'm having trouble finishing it off


-Basically I have a Column with 50 rows
-Each row will consist of the text YES or NO
-I need to get some percentage values of both YES and NO for the column


I can COUNTIF the Yes and No, but how do I get the percentage of the yes's and no's without it taking into consideration all the empty rows in the column

So like

Yes
No
Yes
Yes
No
empty row
Yes
No
empty row

4 Yes / 3 No / 2 Empty so I want the percentage of Yes 4/7 formulated (4Yes+3NO)

 

[shg]

If the empty rows are actuually blank

=countif(a1:a50, "yes") / counta(a1:a50)

 

[Codith]

Awesome thanks!!!!

 

[shg]

You're welcome, good luck.