I'd like to count the number of specific responses to a specific question in
a questionnaire where I have 100 respondents and have the info on one excel
sheet
e.g
I'd like to be able to get the following information:
Question 1 had 42 responses of "Agree", 7 responses of "Neutral", 18
responses of "Disagree"...etc
Question 2 had "90" responses of "Strongly agree", 2 responses of "Disagree"

I'm struggling with the formulas
Can you help?