SUM more results from more IF conditions

@fabio
@fabio ✭✭
edited 12/09/19 in Formulas and Functions

Hi All,

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,

Fabio

 

 

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!