How to add new criteria to my current COUNTIFS formula?

Cristina Lucci

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 :)

Kelly Moore

Hey @Cristina Lucci

Try this

=COUNTIFS(CHILDREN(Plan:Plan), "Fundamentals", CHILDREN(Role:Role), HAS(@cell, "IBX Customer Ops"), CHILDREN(Deliverable:Deliverable), <>"Topic")

Does this work for you?

Kelly

Kelly Moore

Hey @Cristina Lucci

Try this

=COUNTIFS(CHILDREN(Plan:Plan), "Fundamentals", CHILDREN(Role:Role), HAS(@cell, "IBX Customer Ops"), CHILDREN(Deliverable:Deliverable), <>"Topic")

Does this work for you?

Kelly

Cristina Lucci

@Kelly Moore This work, thanks Kelly!