COUNTIFS with AND OR in row

Hi, I am trying to count child rows ONCE where 'not applicable' is false AND either the 'override' is true OR the 'change default' is true. If both are true do not count twice. AI gave me the below formula but it is adding both true columns.

=COUNTIFS([Counter Helper]:[Counter Helper], @cell = "Account", [Change Enforcement Default]:[Change Enforcement Default], 1, [Not Applicable]:[Not Applicable], 0) + COUNTIFS([Override Policy (if available)]:[Override Policy (if available)], 1, [Not Applicable]:[Not Applicable], 0)

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

That's a good start. Now you just need to subtract a 3rd COUNTIFS that counts where both are true. The basic idea is

=COUNTIFS(first is true) + COUNTIFS(second is true) - COUNTIFS(both are true)

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.