how can I use excel to tabulate survey results

G

Guest

Can I use Excel to tabulate survey results, using some sort of counter to
track totals? Thanks.
 
K

kraljb

Can you be more specific in what you mean by that.

If for example it's a survey with multiple choice answers (i.e. A, B
C, D, and E) and Questions (1-10). Assume that question numbers are i
column A, Answers in B, you could use a sumproduct to get the tota
number of Answer "A" for Question 3 like so

=SUMPRODUCT(--($A$1:$A$100=3),--($B$1:$B$100="A"))

You could also add in more information as if you wanted to tabulat
based on other peices of data, such as age, sex, etc. But in al
reality an example would be easier to help with this
 

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

Top