Countifs Multiple Criteria

Travis Avery

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!

Bassam Khalil

Travis Avery

I don't see an answer...??

Bassam Khalil

@Travis Avery

Please try the following formula:

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