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

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?

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?

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?

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?

Try this ......

=COUNTA(D6:D13)/((COUNTBLANK(D6:D13)+COUNTA(D6:D13)))


--
mubashir aziz

If this post helps Don't 4get to click Yes
------------------------------------------------------------------------
mubashir aziz's Profile: http://www.thecodecage.com/forumz/member.php?userid=237
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=97722

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

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" wrote:


Try this ......

=COUNTA(D6:D13)/((COUNTBLANK(D6:D13)+COUNTA(D6:D13)))


--
mubashir aziz

If this post helps Don't 4get to click Yes
------------------------------------------------------------------------
mubashir aziz's Profile: http://www.thecodecage.com/forumz/member.php?userid=237
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=97722

D6:D13 is 8 cells, not 7

5/8 is 62.5%

Try this...............=COUNTIF(D6:D13,"y")/ROWS(D6:D13)


Gord Dibben MS Excel MVP


On Wed, 20 May 2009 05:03:01 -0700, Magic1
wrote:

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" wrote:


Try this ......

=COUNTA(D6:D13)/((COUNTBLANK(D6:D13)+COUNTA(D6:D13)))


--
mubashir aziz

If this post helps Don't 4get to click Yes
------------------------------------------------------------------------
mubashir aziz's Profile: http://www.thecodecage.com/forumz/member.php?userid=237
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=97722

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

=COUNTA(D7:D13)/((COUNTBLANK(D7:D13)+COUNTA(D7:D13)))





Magic1;351462 Wrote:
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" wrote:


Try this ......

=COUNTA(D6:D13)/((COUNTBLANK(D6:D13)+COUNTA(D6:D13)))


--
mubashir aziz

If this post helps Don't 4get to click Yes

------------------------------------------------------------------------
mubashir aziz's Profile: 'The Code Cage Forums - View Profile:
mubashir aziz'
(http://www.thecodecage.com/forumz/member.php?userid=237)
View this thread: 'Excel, Percentof row D6:d13 with \"Y\" expressed
in E5 - The Code Cage Forums'
(http://www.thecodecage.com/forumz/sh...ad.php?t=97722)




--
mubashir aziz

If this post helps Don't 4get to click Yes
------------------------------------------------------------------------
mubashir aziz's Profile: http://www.thecodecage.com/forumz/member.php?userid=237
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=97722