Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Averaging Text vs. Numbers
I have a column that we either enter y for yes or n for no to track
passing scores. Is there a way that I can average the yes and nos from the same column? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Averaging Text vs. Numbers
a combination of the countif and counta functions would do it for you
=COUNTIF(A1:A4,"yes")/COUNTA(A1:A4) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Averaging Text vs. Numbers
=COUNTIF(G:G,"y")/COUNTA(G:G)
and format as a percentage -- HTH Bob Phillips (remove nothere from email address if mailing direct) "NKDodd" wrote in message ... I have a column that we either enter "y" for yes or "n" for no to track passing scores. Is there a way that I can average the yes' and no's from the same column? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Averaging Text vs. Numbers
Thank you very much. I knew I must have been trying to make this harder than
needed... " wrote: a combination of the countif and counta functions would do it for you =COUNTIF(A1:A4,"yes")/COUNTA(A1:A4) |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Averaging Text vs. Numbers
On Thu, 27 Apr 2006 07:30:02 -0700, NKDodd
wrote: I have a column that we either enter y for yes or n for no to track passing scores. Is there a way that I can average the yes and nos from the same column? One way. With scores in A1:A20 and y/n in B1:B10 Average of the y cells =SUMIF(B1:B20,"y",A1:A20)/SUMPRODUCT((A1:A20<"")*(B1:B20="y")) Average of the n cells just change the y's to n's HTH __ Richard Buttrey Grappenhall, Cheshire, UK __________________________ |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Averaging Text vs. Numbers
Thanks for your help... it worked great
"Bob Phillips" wrote: =COUNTIF(G:G,"y")/COUNTA(G:G) and format as a percentage -- HTH Bob Phillips (remove nothere from email address if mailing direct) "NKDodd" wrote in message ... I have a column that we either enter "y" for yes or "n" for no to track passing scores. Is there a way that I can average the yes' and no's from the same column? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I use "VLOOKUP" with cells containing both Text & Numbers? | Excel Worksheet Functions | |||
converting numbers to text | New Users to Excel | |||
How do I convert numbers stored as text with spaces to numbers | Excel Discussion (Misc queries) | |||
How to reformat numbers stored as text (apostrophe at beginning) | Excel Discussion (Misc queries) | |||
Converting Numbers to Text properly | Excel Discussion (Misc queries) |