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

Find more posts tagged with

Accepted answers

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

All comments

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.