Excel, Percentof row D6:d13 with "Y" expressed in E5
How do I get a percent of D6:D13 with the letter "Y" in E5?
|
Excel, Percentof row D6:d13 with "Y" expressed 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? |
Excel, Percentof row D6:d13 with "Y" expressed 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? |
Excel, Percentof row D6:d13 with "Y" expressed 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? |
Excel, Percentof row D6:d13 with "Y" expressed 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? |
Excel, Percentof row D6:d13 with "Y" expressed 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 |
Excel, Percentof row D6:d13 with "Y" expressed in E5
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 |
Excel, Percentof row D6:d13 with "Y" expressed in E5
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 |
Excel, Percentof row D6:d13 with "Y" expressed in E5
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 |
Excel, Percentof row D6:d13 with "Y" expressed in E5
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 |
All times are GMT +1. The time now is 02:24 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com