Adding Multiple Criteria + Does Not Include

Ashley Thomas

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!

Ashley Thomas

Carson Penticuff

I am not sure whether you mean you want individual counts for each of the three selections, or if you want a total of all three selections. This will give you the latter:

=COUNTIFS([Drink Selection]:[Drink Selection], <> "Soda", [Lunch Selection]:[Lunch Selection], OR(@cell = "Turkey", @cell = "Ham", @cell = "Roast Beef"))

Paul Newcome

I was about to say the same thing as @Carson Penticuff.

<> means "not equal to"

Ashley Thomas

Thanks! I had the same formula, but the order of actions was reversed. It worked when I switched them around. Much appreciated!