Home 
Search 
Today's Posts 
#1
Posted to microsoft.public.excel.worksheet.functions




Counting the occurrence of "Y" & "N" in Excel 2007
I'm just now trying to learn the COUNTIF function but obviously am having a
problem... If the cell range is (A5:A370) and I need to count the "Y" 's and the "N" 's with the answer resulting in the following format: YYYY/NNNN what would I use? Any help apreciated!  ~Christi 
#2
Posted to microsoft.public.excel.worksheet.functions




Counting the occurrence of "Y" & "N" in Excel 2007
=REPT("Y",COUNTIF(A5:A370,"Y"))&"/"&REPT("N",COUNTIF(A5:A370,"N"))
 Max Singapore http://savefile.com/projects/236895 Downloads:19,000 Files:362 Subscribers:61 xdemechanik  "Christi" wrote: I'm just now trying to learn the COUNTIF function but obviously am having a problem... If the cell range is (A5:A370) and I need to count the "Y" 's and the "N" 's with the answer resulting in the following format: YYYY/NNNN what would I use? Any help apreciated!  ~Christi 
#3
Posted to microsoft.public.excel.worksheet.functions




Counting the occurrence of "Y" & "N" in Excel 2007
Hi,
Try this: =COUNTIF(A5:A370,"Y")&"/"&COUNTIF(A5:A370,"N") However if your really trying to get the ratio =COUNTIF(A5:A370,"Y")/COUNTIF(A5:A370,"N") Might be sufficient. You can force the display of as many digits as you want by using the custom format code: # ????/???? In this case it would display up to 4 digits/ 4 digits  Thanks, Shane Devenshire "Christi" wrote: I'm just now trying to learn the COUNTIF function but obviously am having a problem... If the cell range is (A5:A370) and I need to count the "Y" 's and the "N" 's with the answer resulting in the following format: YYYY/NNNN what would I use? Any help apreciated!  ~Christi 
#4
Posted to microsoft.public.excel.worksheet.functions




Counting the occurrence of "Y" & "N" in Excel 2007
=rept("y",countif(a5:a370,"y"))&"/"&rept("n",countif(a5:a370,"n"))
You really want: yyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyy/nnnnnnnnnnnnnn or maybe: =countif(a5:a370,"y")&"/"&countif(a5:a370,"n") to see something like: 140/139 Christi wrote: I'm just now trying to learn the COUNTIF function but obviously am having a problem... If the cell range is (A5:A370) and I need to count the "Y" 's and the "N" 's with the answer resulting in the following format: YYYY/NNNN what would I use? Any help apreciated!  ~Christi  Dave Peterson 
#5
Posted to microsoft.public.excel.worksheet.functions




Counting the occurrence of "Y" & "N" in Excel 2007
Thanks fella's! I knew this was my best chance. :0)
 ~Christi "Dave Peterson" wrote: =rept("y",countif(a5:a370,"y"))&"/"&rept("n",countif(a5:a370,"n")) You really want: yyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyy/nnnnnnnnnnnnnn or maybe: =countif(a5:a370,"y")&"/"&countif(a5:a370,"n") to see something like: 140/139 Christi wrote: I'm just now trying to learn the COUNTIF function but obviously am having a problem... If the cell range is (A5:A370) and I need to count the "Y" 's and the "N" 's with the answer resulting in the following format: YYYY/NNNN what would I use? Any help apreciated!  ~Christi  Dave Peterson 
#6
Posted to microsoft.public.excel.worksheet.functions




Counting the occurrence of "Y" & "N" in Excel 2007
Aha, I focused on this part in your orig. post, wrongly it seems:
.. with the answer resulting in the following format: YYYY/NNNN  Max Singapore http://savefile.com/projects/236895 Downloads:19,000 Files:362 Subscribers:61 xdemechanik  
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)  
how i convert "100" to "hundred"( number to text) in excel2007  Excel Worksheet Functions  
change "true" and "false" to "availble" and "out of stock"  Excel Worksheet Functions  
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 