M
Magic1
How do I get a percent of D6
13 with the letter "Y" in E5?
13 with the letter "Y" in E5?
F
FSt1
hi
try this....
=COUNTIF(D613,"y")/COUNTA(D613)
this formula assumes that D613 is all text.
Regards
FSt1
try this....
=COUNTIF(D6
13,"y")/COUNTA(D613)this formula assumes that D6
13 is all text.Regards
FSt1
F
FSt1
oops
you said "y" was in E5....so.....
=COUNTIF(D613,E5)/COUNTA(D613)
regards
FSt1
you said "y" was in E5....so.....
=COUNTIF(D6
13,E5)/COUNTA(D613)regards
FSt1
S
Sheeloo
FYI - CountA counts cells which are not empty... need not be text.
I think your first post was what was required.
I think your first post was what was required.
M
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 ....
asking.
I have seven (D7
13) elements that require a level of completion.Completion is determined by the letter "Y" being entered in the element cell
(D7
13). I want to show the % level of completion in cell E6Tks ....
M
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.
of the seven cells in D6:d13 have "y" entered in each, which gives me a 71%
completion.
G
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
13 is 8 cells, not 75/8 is 62.5%
Try this...............=COUNTIF(D6
13,"y")/ROWS(D613)Gord Dibben MS Excel MVP