Need to count instances of occurrences across multiple sheets

Appreciate your time, first and foremost.

I have a survey that was given to students, it is now my responsibility to compile the results.

Student Survey.docx

This is the survey.

I was thinking of going through each survey and putting info into a spreadsheet where "disagree" would be designated as "1", "Neutral" as "2", and "agree" as "3". I believe this would be the fastest way to tally.

Capture.PNG

The results would look something like this. There are a total of 200 surveys that I need to get through so I was thinking of doing this on 200 different sheets.

Is there a better way to do this?

Thanks!

Jason

JBeaucaire,

I wouldn't have thought of that... I was thinking that I might have to get fancy with it. Apparently not. How would you go about comparing Q1 Beginning with Q1 End?

Thank you.