Countifs with OR

I feel like I almost have it:

=COUNTIFS({MMES},"0", @cell), {Disease Extent}, OR(CONTAINS("Proctitis", @cell), (CONTAINS("No disease activity", @cell)

Count if the column titled MMES has "0" and the column titled Disease Extent has "Proctitis" OR has "No disease activity"

HELP!

Find more posts tagged with

Formulas

Accepted answers

All comments

Paul Newcome

The issue is actually with the first part. You do not need the "@cell" reference or the closing parenthesis there.

=COUNTIFS({MMES},"0", ~~@cell)~~, {Disease Extent}, OR(CONTAINS("Proctitis", @cell), CONTAINS("No disease activity", @cell)))

=COUNTIFS({MMES},"0", {Disease Extent}, OR(CONTAINS("Proctitis", @cell), CONTAINS("No disease activity", @cell)))

RGarrels

Thank you!!

Paul Newcome

Happy to help. 👍️

RGarrels

Is there a small tweak I could add to the above statement to NOT count if the value in another column is "Screen Fail"?

Paul Newcome

You would simply add another range/criteria set.

{Range}, @cell <> "Screen Fail"

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.