Need help with CountIF formula referencing two columns on another sheet with an OR statement

Current attempt:

=COUNTIFS({Sheet Name - Standard}, CONTAINS("UM", @cell), {Sheet Name - Annual}, OR("yes", "add"))

The gist is, another sheet, Sheet Name, has a column, Standard, and a column Annual, and for every Standard that is UM, we want to count if the Annual column contains "Yes" or "Add". There is a third option in the annual column "No" that is present along with Add at times, but is irrelevant to the count. Meaning if that cell has No and Add, we still want to count it.

Any help is appreciated, and it must be a formula, we looked into reports and were directed that is not what is desired.

Find more posts tagged with

Formulas

Accepted answers

Paul Newcome

Try this:

=COUNTIFS({2023 Corporate Accreditation - STD}, CONTAINS("UM", @cell), {2023 Corporate Accreditation - Annual}, OR(CONTAINS("yes", @cell), CONTAINS("add", @cell)))

All comments

jackkelley

Updating as I keep tinkering, new current formula:

=COUNTIFS({2023 Corporate Accreditation - STD}, CONTAINS("UM", @cell), {2023 Corporate Accreditation - Annual}, CONTAINS(OR("yes", "add"), @cell))

Paul Newcome

Try this:

=COUNTIFS({2023 Corporate Accreditation - STD}, CONTAINS("UM", @cell), {2023 Corporate Accreditation - Annual}, OR(CONTAINS("yes", @cell), CONTAINS("add", @cell)))

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.