Adding Multiple Criteria + Does Not Include

Ashley Thomas
Ashley Thomas ✭✭
edited 06/12/23 in Formulas and Functions

Hello, Smartsheet community! I am stumped on a function. I have attached a photo of a dummy sheet with the same functionality I am trying to achieve.

Using the example, how would I set up a formula which adds together the lunch selections of turkey, ham, and roast beef if they DID NOT choose soda as their drink? Lunch options of Veggie and Egg Salad are not to be captured.

I have tried several different formulas, but the number is either off or it doesn't capture the 'did not' correctly.

Thank you!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!