Countifs Multiple Criteria


I am trying to count multiple criteria. For example, here is my formula:

=COUNTIFS({ALS Resolvion Claims Tracker (INT) Range 1}, "ART Asset Adjusters" or "Paramount Recovery", {Client A Claim Tracker (Internal) Range 1}, "NOT STARTED")

When I put in the "or" and "Paramount Recovery", I get an error message. Please help!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!