CONTAINS in COUNTIF referencing to another sheet returns #UNPARSABLE.

I want to count all the cells with the word "Exempt" in the Column/Reference {Stat}. Using the formula below gives me the #UNPARSABLE error.

=COUNTIFS({BIN}, [BIN #]@row, {Stat}, CONTAINS("Exempt",{Stat})

=COUNTIFS({BIN}, [BIN #]@row, {Stat}, CONTAINS("Exempt",{Stat}@cell)

=COUNTIFS({BIN}, [BIN #]@row, {Stat}, CONTAINS("Exempt",{Stat}@row)

However, this one works, but does not count the all varieties of Exempt items in the column:

=COUNTIFS({BIN}, [BIN #]@row, {Stat}, "Exempt Unit(s)")

Find more posts tagged with

Formulas

Accepted answers

All comments

Jeff Reisman

Since you're already supply the second criteria range ({Stat}), you don't need to list it again in the CONTAINS. Use @cell by itself. Also, you need a second end parentheses on the end of the formula, since you have to close off your CONTAINS function as well as the COUNTIFS formula.

=COUNTIFS({BIN}, [BIN #]@row, {Stat}, CONTAINS("Exempt", @cell))

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.