Provide Sum of responses broken down into 2 categories

[mookrog]

I have a set of data which i took from a survey i created in MS Forms. I've used it a number of pivot tables and charts to get some of the data i want but i cant get it to sum total a particular response across all the questions. I have two groups that i am interested in and i want to know how often each group responded "strongly Agree", "somewhat Agree" etc through to "Strongly disagree"

My desired end state would be:

Strongly Agree Somewhat agree Slightly Agree Slightly DisAgree Somewhat Disagree Strongly DisAgree
Engineer 22 17 11 4 6 7
Analyst 11 10 9 22 5 9

I would then be want to take that output and put it into a line chart

[PaulM100]

You can use a sumproduct, like: =SUMPRODUCT((Table1[[Are you:2]:[Are you:2]]=$I2)*(Table1[[Q1]:[Q4]]=J$1))