Countifs with OR

RGarrels

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!

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"