| Home |
| Search |
| Today's Posts |
|
#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? |
| 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 | |||
Threaded Mode
