How to create a countif formula with OR

Options
SJTA
SJTA ✭✭✭✭✭

I am trying to create a formula across columns with different values in a cell. I have the formula for one value, Preliminary Draft. This works fine.

=COUNTIFS({Comments Log Range 1}, [Document Name]@row, {Comments Log Range 2}, "Preliminary Draft", {Comments Log Range 4}, "Open")

However, the value in range 2 can also be "Intermediate", or "Final".

This is what I tried:

=COUNTIFS(({Comments Log Range 1}, [Document Name]@row), OR({Comments Log Range 2}, "Intermediate", {Comments Log Range 2}, "Preliminary Draft", {Comments Log Range 2}, "Final"), {Comments Log Range 4}, "Open"))

Smartsheet says its UNPARSEABLE.

I am sure it's a simple solution, but I can't figure it out. Thanks.

Tags:

Answers