I'm stuck on a COUNTIFS formula

I'm stuck on a formula trying to get a total that only looks for specific criteria.

This is what I wrote: =COUNTIFS(Status53:Status114, NOT(HAS("Backlog", Priority53:Priority114, "High")))

It's not getting the the info I need. I'm trying to find out what tasks have a "High" Priority but aren't Status "Backlog".

I'm sure it's a simple steps that I'm missing. Thanks!

Find more posts tagged with

Formulas

Accepted answers

ChloeSmith

Hello,

Does this work? =COUNTIFS(Status53:Status114, NOT(@cell = "Backlog"), Priority53:Priority114, "High")

All comments

ChloeSmith

Hello,

Does this work? =COUNTIFS(Status53:Status114, NOT(@cell = "Backlog"), Priority53:Priority114, "High")

Josh L.

@ChloeSmith Hallelujah! Yes, it worked! I've been trying different options for over an hour. Thank you!

ChloeSmith

@Josh L. Woot!! Glad it worked!

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.