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 ....

 

[mubashir aziz]

Try this ......

=COUNTA(D613)/((COUNTBLANK(D613)+COUNTA(D613)))

 

[Pecoflyer]

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 ....

Another one:
=countif(d6:d13,"y")/columns(d6:d13)

 

[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.

 

[mubashir aziz]

I was counting from D6 where your requirements is for from D7. anyhow
i've chenged and you can try it

=COUNTA(D713)/((COUNTBLANK(D713)+COUNTA(D713)))

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.


mubashir aziz'
(http://www.thecodecage.com/forumz/member.php?userid=237)
in E5 - The Code Cage Forums'
(http://www.thecodecage.com/forumz/showthread.php?t=97722)