I am trying to create a pivot table that will calculate survey results I dumped into excel.
I can get it to count 1 question and count the responses
Agree
Disagree
somewhat agree
somewhat disagree
The problem is I have about 100 questions and when I put other questions in there the counts are inaccurate. I could do this with countifs statements but there has got to be an easy way through pivot tables...any thoughts or suggestions would be appreciated...
Bookmarks