Adding Multiple Criteria + Does Not Include

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!

Find more posts tagged with

Formulas

functionality

Accepted answers

All comments

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!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.