Magic1;351221 Wrote:
After reading my own question, I realize that I was not clear in what I
was
asking.
I have seven (D7:D13) elements that require a level of completion.
Completion is determined by the letter "Y" being entered in the element
cell
(D7:D13). I want to show the % level of completion in cell E6
Tks ....
"Sheeloo" wrote:
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?
Another one:
=countif(d6:d13,"y")/columns(d6:d13)
--
Pecoflyer
Cheers -
------------------------------------------------------------------------
Pecoflyer's Profile:
http://www.thecodecage.com/forumz/member.php?userid=14
View this thread:
http://www.thecodecage.com/forumz/sh...ad.php?t=97722