software

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
=COUNTIF(A:A,quot;yesquot;)

etc.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;ETquot; gt; wrote in message
.. .
gt; I am doing a mini survey of 8 questions to approximately 400 people. Some
gt; cells I have formatted as only # responses and at the end I have a total
for
gt; those. I have 3 questions that I have added a drop down list of possible
gt; responses: yes,no,n/a. I would like to be able to have excel (if
possible)
gt; add up the yes / no and n/a responses for each of the 3 questions. Maybe
I
gt; should not be using a drop down list for the possible responses? How do I
gt; get it to add these up for me? (I can change the drop down to anything
gt; else--but the responses need to be yes / no or n/a).
gt;
gt; Thanks in advance for any help!! (I am using Excel 2002)
gt;
gt; Elissa
gt;
gt;
Thanks so much--I knew it would be something real simple!!quot;Bob Phillipsquot; gt; wrote in message
...
gt; =COUNTIF(A:A,quot;yesquot;)
gt;
gt; etc.
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from email address if mailing direct)
gt;
gt; quot;ETquot; gt; wrote in message
gt; .. .
gt;gt; I am doing a mini survey of 8 questions to approximately 400 people.
gt;gt; Some
gt;gt; cells I have formatted as only # responses and at the end I have a total
gt; for
gt;gt; those. I have 3 questions that I have added a drop down list of possible
gt;gt; responses: yes,no,n/a. I would like to be able to have excel (if
gt; possible)
gt;gt; add up the yes / no and n/a responses for each of the 3 questions.
gt;gt; Maybe
gt; I
gt;gt; should not be using a drop down list for the possible responses? How do
gt;gt; I
gt;gt; get it to add these up for me? (I can change the drop down to anything
gt;gt; else--but the responses need to be yes / no or n/a).
gt;gt;
gt;gt; Thanks in advance for any help!! (I am using Excel 2002)
gt;gt;
gt;gt; Elissa
gt;gt;
gt;gt;
gt;
gt;