Excel, Percentof row D6:d13 with "Y" expressed in E5

[Magic1]

How do I get a percent of D613 with the letter "Y" in E5?

 

[FSt1]

hi
try this....
=COUNTIF(D613,"y")/COUNTA(D613)

this formula assumes that D613 is all text.
Regards
FSt1

 

[FSt1]

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

regards
FSt1

 

[Sheeloo]

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

I think your first post was what was required.

 

[Magic1]

After reading my own question, I realize that I was not clear in what I was
asking.
I have seven (D713) elements that require a level of completion.
Completion is determined by the letter "Y" being entered in the element cell
(D713). I want to show the % level of completion in cell E6

Tks ....

 

[Magic1]

Tks... the below formula gives me 68% completion when it should be 71%. Five
of the seven cells in D6:d13 have "y" entered in each, which gives me a 71%
completion.

 

[Gord Dibben]

D613 is 8 cells, not 7

5/8 is 62.5%

Try this...............=COUNTIF(D613,"y")/ROWS(D613)


Gord Dibben MS Excel MVP

Tks... the below formula gives me 68% completion when it should be 71%. Five
of the seven cells in D6:d13 have "y" entered in each, which gives me a 71%
completion.