#UNPARSEABLE error in COUNTIF formula with OR function

Hello,

I am unsure why this formula is returning #UNPARSEABLE.

=COUNTIFS({Task List - Texas Projects FND Prepare}, @cell = Name@row, OR(({Task List - Texas Projects Agent Status}, @cell = "Red"), ({Task List - Texas Projects PM Status}, @cell = "Red")))

It is supposed to count the number of times a name in the "FND prepare" column matches the referenced name on the sheet, where either the "Agent Status" or "PM Status" columns are red (indicating corrections need to be made). I can get the below (less complex) formula to work no problem, but when I try several variations of the above all of them return errors.

=COUNTIFS({Task List - Texas Projects FND Prepare}, @cell = Name@row, {Task List - Texas Projects Agent Status}, @cell = "Red")

Also attached is a screenshot for reference

Find more posts tagged with

Sheets

Formulas

Solution Center

Project Management

Cell linking

Accepted answers

All comments

JamesB

@PinnCason Looks like you have to many parentheses in your OR argument.

Try this...

=COUNTIFS({Task List - Texas Projects FND Prepare}, @cell = Name@row, OR({Task List - Texas Projects Agent Status}, @cell = "Red", {Task List - Texas Projects PM Status}, @cell = "Red"))

PinnCason

Hello @JamesB,

Sorry for the delay in reply. This now returns #INVALID DATA TYPE. I found a work around by making two columns; one for the agent status and one for the PM status. I then just make a third column to sum the two.

Thank you!

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.