COUNTIFS and NOT Function

Silvia Frei

I'm looking to count the number of instances an epic is listed, but to exclude Closed and Done ones.

I am trying this formula which gives an error

=COUNTIFS(JIRA:JIRA, CONTAINS("TPM", @cell), [Issue Type]:[Issue Type], "Epic", NOT(Status:Status, "Closed", "Done"))

Any suggestions?

3.JPG

Find more posts tagged with

Accepted answers

All comments

Stefan

Hi,

this works for me:

=COUNTIFS(JIRA:JIRA, CONTAINS("TPM", @cell), [Issue Type]:[Issue Type], ="Epic", Status:Status, <>"Closed", Status:Status, <>"Done")

For you too?

Greetings

Stefan

Silvia Frei

Perfect! Thanks :)

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.