Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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?
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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? |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#8
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#9
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#10
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
Help!!! Enter "7" in a cell and Excel changes the "7" to "11" immediately!!! | Excel Discussion (Misc queries) | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel |