How do I create an IF for a line of cells that if true picks multiple values from cells?

Options

Hi, I'm trying to do this elegantly

=SUM(IF(E7:U7="x";value1 for E7, value2 for F7, value3 for G7...;0)

Can it be done?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!