COUNTIFS with OR in Ranges

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


Range 2 = Emily


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

This throws #UNPARSEABLE

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

Best Answer

  • David Tutwiler
    David Tutwiler Overachievers Alumni
    Answer ✓

    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"))


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!