COUNTIFS with OR in Ranges

Detrie Zacharias

I'm trying to count the records in another sheet.

Where:

Range 2 = Emily

AND

Range 3 = either "Awaiting Feedback" OR "On Hold"

This throws #UNPARSEABLE

=COUNTIFS({Range 2}, ="Emily",OR({ Range 3}, ="Awaiting Feedback",{Range 3}, ="On Hold", ))

David Tutwiler

You have too many commas in your OR function. Also, you need to define the range, then do the OR on the conditional part of the function. This should fix it:

=COUNTIFS({Range 2}, "Emily", { Range 3}, OR(@cell ="Awaiting Feedback", @cell ="On Hold"))

David Tutwiler

You have too many commas in your OR function. Also, you need to define the range, then do the OR on the conditional part of the function. This should fix it:

=COUNTIFS({Range 2}, "Emily", { Range 3}, OR(@cell ="Awaiting Feedback", @cell ="On Hold"))

Detrie Zacharias

Thanks David.. That did it!

I appreciate the help

David Tutwiler

No problem, glad it's working