Nested Or within Countifs formula

Hi,

I am hoping to see if I can get help with the following formula:

=COUNTIFS([Area of focus]:[Area of focus], "HGIT", Status:Status, "Complete", OR([Status:Status] = "Approved"), [Channel:Channel], <>"internal comms")

Essentially, my goal is to count items that are for "HGIT" that are either complete or approved but not related to internal communication. I am using the brackets in this example to illustrate an entire column.

Thanks in advance!

-Jake

Find more posts tagged with

Formulas

Reports

functionality

Accepted answers

All comments

Jacob Jennings

=COUNTIFS([Area of focus]:[Area of focus], "HGIT", Status:Status, "Complete", Channel:Channel, <>"internal comms") + COUNTIFS([Area of focus]:[Area of focus], "HGIT", Status:Status, "Approved", Channel:Channel, <>"internal comms")

Resolved my issue. Apparently you cannot nest an "Or" statement within countifs as it is an "and" based function.

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.