I need help scoring the following question, which is in three parts. If the
answer to Question 1 is #3, and Question 1A is #3 and Question 1B is #3, the
score for this series of questions is 2. How do I get Excel to come up with
that answer?

Question 1
1 Never ---------- 9
2 Less than half the time ---------- 11A and 11B
3 More than half the time ---------- 11A and 11B x
4 Nearly all the time? (most/all) ----------11A and 11B
DK (99)
Question 1A
1 A little
2 Some
3 A lot x
4 Almost entirely? (Entirely/Completely/ All)
DK (99)
Question 1B
1 Only one or two
2 Several
3 Most x
4 Did you lose interest in virtually everything? (Everything/all)
DK (99)
Score 2