SUM more results from more IF conditions
image different questions (1 for each column) with 3 possible drop-down answers (Yes, Maybe, Not). Every combination question/answer generate a different score.
Ex: Question 1
- Y - 3 points
- M - 5 points
- N - 8 points
I need to have in a single cell the sum of the score of a gruop of question.
Have you any tips or suggestion for me?
Many thanks in advance,
Help Article Resources
Check out the Formula Handbook template!