Complicated scoring and summing of unique cell values - serious help needed!

Dear all,
This is a new post to seek help on calculating cell scores and then adding each up to arrive at a total row score.

I have attached a spreadsheet which includes 9 columns for 9 persons I need to score. As you will see the scoring for each cell depends on the values in each cell, which can range from 1 to 5.

The scoring is as follows:
they get a score of 1 point if they answered 1 or 2 in column B (ty1)
they get a score of 1 point if they answered 3 in column C (ty2)
they get a score of 1 point if they answered 3 in column D (ty3)
they get a score of 1 point if they answered 1 in column E (ty4)
they get a score of 1 point if they answered 1 in column F (ty5)
they get a score of 1 point if they answered 3 in column G (ty6)
they get a score of 1 point if they answered 1 or 2 in column H (ty7)
they get a score of 1 point if they answered 2 in column I (ty8)
they get a score of 1 point if they answered 3 in column J (ty9)

total score= 0 to 9.

To make things easier (not sure for whom...lol) I have included the scoring protocol in the spreadsheet and manually calculated the scores to show those what they should be. If at all possible, I do not want zeros to appear in row totals where persons have not responded to any of the questions.

I appreciate that this is not an easy request, so I do thank you in advance for taking the time to read and reply to this thread.

All the best.

Try this formula

=SUMPRODUCT(SIGN((B2:J2={1,3,3,1,1,3,1,2,3})+(B2:J2={2,3,3,1,1,3,2,2,3})))

Here is another version

=SUMPRODUCT(--(B2:J2={1,3,3,1,1,3,1,2,3}))+(B2=2)+(H2=2)

Originally Posted by Bob Phillips

Here is another version

=SUMPRODUCT(--(B2:J2={1,3,3,1,1,3,1,2,3}))+(B2=2)+(H2=2)

Hi Bob,
Thanks so much for your quick helpful reply. Both seem to work so I will definitely not lose sleep tonight!

All the best.