converting questionnaire to points score system on different sheet

hello
I did a survey using google forms, each question had 5 different answers ( in words). 12 questionnaire items with 5 ordinal response options each.
I want to form an index/ key, to convert the answers to points. example: not at all= 1, in some cases= 2, all the time = 3, but not all the questions have the same answers, so for each question (row) I need to make a specific scoring index?

the first rows of the data composed of general info, then rows with questions. the main point is to have a summary of all the points in each column ( each column composed of all the answers for the different questions ).


thanks ahead.

sorry, it took a while ..
I translated part of the table

Try this in I2:

=SUMPRODUCT(SUMIF($N$2:$N$6,C2:H2,$O$2:$O$6))

thanks !!
it's working great.

Is there a way to make it automatically for the whole table? is there a macro I can use for it for the whole table?

Thank you so much for the responses, I used it just as you suggested, and it works great,
another question related to the same topic

in case I have different answers with the same point grading system, how do I do it this time? ( I added a new sheet ).
In my real table, I have 15 different questions, with 7 different sets of answers.

Try this in H2:

=SUMPRODUCT(($B$1:$G$1=$M$1:$R$1)*(B2:G2=$M$2:$R$6)*$S$2:$S$6)

thank you !!!

H2 cell ,array formula , copy and drag down

HTML Code: