I want to add up various responses to a questionnaire by using select rules.
For example if in A2 someone answered 1, I want that to count as 1 point, and
if someone answered 1, I want that to count as 2 points. Anything else would
be a zero. What sort of formula could I use to do that and then add up the
row at the end?