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

Find more posts tagged with

Formulas

Sheet Summary

Accepted answers

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

All comments

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!

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.