How to add new criteria to my current COUNTIFS formula?

Hi all!

Not sure how to add the criteria do not add to count if cell = "Topic" to my current COUNTIFS formula.

Current foluma is: =COUNTIFS(CHILDREN(Plan:Plan), "Fundamentals", CHILDREN(Role:Role), HAS(@cell, "IBX Customer Ops"))

I need to add 'AND if the the "Deliverable" cell does not equal "Topic" '.

Thanks in advance :)

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!