My problem:
I have the survey data in an excel sheet, one respondent per row and one question per column.

What i would like to do is show the number of grades per question (1-5) based on several criteria (the first 6 questions) for publishing on a company intranet.

Could use a pivottable with reformatting of the data but the number of row would be extremely large (have 25000 respondents and 70 questions)

Have tried using productsum, works but to slow for interactivity.

Would be very grateful for tips of how to do this.
Thinking of creating separate pivot tables for each question but that would mean a lot of tables

/Johan