FYI - CountA counts cells which are not empty... need not be text.

I think your first post was what was required.

"FSt1" wrote:

oops
you said "y" was in E5....so.....
=COUNTIF(D6:D13,E5)/COUNTA(D6:D13)

regards
FSt1

"FSt1" wrote:

hi
try this....
=COUNTIF(D6:D13,"y")/COUNTA(D6:D13)

this formula assumes that D6:D13 is all text.
Regards
FSt1

"Magic1" wrote:

How do I get a percent of D6:D13 with the letter "Y" in E5?