| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I want to be able to input "Y" or "N" and tally them as 1 or 0.
Out of 30 possible entries, I can have either y, n or blank. I want to
equate the sum of the "Y" and divide by the total number of y+n (not blank) entries. Any ideas? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I want to be able to input "Y" or "N" and tally them as 1 or 0.
To count the "Y"'s use this formula:
=COUNTIF(A1:A30,"Y") To count the nonblanks: =COUNTA(A1:A30) And, to combine the two: =COUNTIF(A1:A30,"Y")/COUNTA(A1:A30) HTH, Elkar "lia" wrote: Out of 30 possible entries, I can have either y, n or blank. I want to equate the sum of the "Y" and divide by the total number of y+n (not blank) entries. Any ideas? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I want to be able to input "Y" or "N" and tally them as 1 or 0.
=COUNTIF(A:A,"Y")/SUM(COUNTIF(A:A,{"Y","N"}))
-- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "lia" wrote in message ... Out of 30 possible entries, I can have either y, n or blank. I want to equate the sum of the "Y" and divide by the total number of y+n (not blank) entries. Any ideas? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I want to be able to input "Y" or "N" and tally them as 1 or 0.
if your data is in cells a1:a30 try =COUNTIF(A1:A30,"y")/COUNTA(A1:A30)
-- John MOS Master Instructor Office 2000, 2002 & 2003 Please reply & rate any replies you get Ice Hockey rules (especially the Wightlink Raiders) "lia" wrote: Out of 30 possible entries, I can have either y, n or blank. I want to equate the sum of the "Y" and divide by the total number of y+n (not blank) entries. Any ideas? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I want to be able to input "Y" or "N" and tally them as 1 or 0
Thanks, I was trying to use SUMIF, but it was too clunky. This is elegant.
"Elkar" wrote: To count the "Y"'s use this formula: =COUNTIF(A1:A30,"Y") To count the nonblanks: =COUNTA(A1:A30) And, to combine the two: =COUNTIF(A1:A30,"Y")/COUNTA(A1:A30) HTH, Elkar "lia" wrote: Out of 30 possible entries, I can have either y, n or blank. I want to equate the sum of the "Y" and divide by the total number of y+n (not blank) entries. Any ideas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 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 | |||
| create links to check boxes marked "good" fair"and "bad" | Excel Worksheet Functions | |||
| Complex if test program possible? If "value" "value", paste "value" in another cell? | Excel Discussion (Misc queries) | |||
| Insert "-" in text "1234567890" to have a output like this"123-456-7890" | Excel Discussion (Misc queries) | |||
Linear Mode
