Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
adding up yes, no, n/a responses
I am doing a mini survey of 8 questions to approximately 400 people. Some
cells I have formatted as only # responses and at the end I have a total for those. I have 3 questions that I have added a drop down list of possible responses: yes,no,n/a. I would like to be able to have excel (if possible) add up the yes / no and n/a responses for each of the 3 questions. Maybe I should not be using a drop down list for the possible responses? How do I get it to add these up for me? (I can change the drop down to anything else--but the responses need to be yes / no or n/a). Thanks in advance for any help!! (I am using Excel 2002) Elissa |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
adding up yes, no, n/a responses
=COUNTIF(A:A,"yes")
etc. -- HTH Bob Phillips (remove nothere from email address if mailing direct) "ET" wrote in message .. . I am doing a mini survey of 8 questions to approximately 400 people. Some cells I have formatted as only # responses and at the end I have a total for those. I have 3 questions that I have added a drop down list of possible responses: yes,no,n/a. I would like to be able to have excel (if possible) add up the yes / no and n/a responses for each of the 3 questions. Maybe I should not be using a drop down list for the possible responses? How do I get it to add these up for me? (I can change the drop down to anything else--but the responses need to be yes / no or n/a). Thanks in advance for any help!! (I am using Excel 2002) Elissa |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
adding up yes, no, n/a responses
Thanks so much--I knew it would be something real simple!!
"Bob Phillips" wrote in message ... =COUNTIF(A:A,"yes") etc. -- HTH Bob Phillips (remove nothere from email address if mailing direct) "ET" wrote in message .. . I am doing a mini survey of 8 questions to approximately 400 people. Some cells I have formatted as only # responses and at the end I have a total for those. I have 3 questions that I have added a drop down list of possible responses: yes,no,n/a. I would like to be able to have excel (if possible) add up the yes / no and n/a responses for each of the 3 questions. Maybe I should not be using a drop down list for the possible responses? How do I get it to add these up for me? (I can change the drop down to anything else--but the responses need to be yes / no or n/a). Thanks in advance for any help!! (I am using Excel 2002) Elissa |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rounding Error when adding or subtracting two cells | Excel Worksheet Functions | |||
Sum only adding rows on page instead of entire spreadsheet - help | Excel Discussion (Misc queries) | |||
adding vertical bars to an embedded chart using VBA | Excel Discussion (Misc queries) | |||
help neede with adding times | Excel Discussion (Misc queries) | |||
problem adding | Excel Discussion (Misc queries) |