Can I use Excel to tabulate survey results, using some sort of counter to
track totals? Thanks.
--
Maiadd
Can I use Excel to tabulate survey results, using some sort of counter to
track totals? Thanks.
--
Maiadd
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 in column A, Answers in B, you could use a sumproduct to get the total 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 tabulate based on other peices of data, such as age, ***, etc. But in all reality an example would be easier to help with this.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks