Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

Excluding Multiple Options

 I am having a real challenge with a particular function. I'm thinking someone will know this right off the top of your head.

=SUMIFS({Digital Marketing Workflow- Total Hours}, {Digital Marketing Workflow- Priority}, <>"Sub-Category", {Digital Marketing Workflow- Project Cat}, "Advertising: Concept")

I am trying to exclude multiple priorities similar to <>"Sub-Category". For instance, I'm also trying to exclude a selection called, "Sub-sub-category". I've tried it multiple ways, with a comma, with an AND as well as an OR @cell statements, and I keep getting will not parse messages. Can you assist?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions