adding up yes, no, n/a responses

E

ET

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
 
B

Bob Phillips

=COUNTIF(A:A,"yes")

etc.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Prefilled Outlook Yes Voting Button response 0
USING DATA VALIDATION WITH CONDITIONAL LOGIC 2
How do I add up texts as fixed number values in a row? 7
conditional formating / linked cells? 7
On and Off problem 1
Assign values to names in a drop-down list? 3
Making checkboxes mutually exclusive 3
macro that brings user to cell based on "yes/no" response 2

Top