Contains If Returning Incorrect Argument Set

Hello,

I created this formula:

=COUNTIFS(CONTAINS("2009", {Protocol #}), {Amendment}, "0")

To review a list of Protocol Numbers (column) that contain 2009 (the year, part of the protocol number) and are not amendments (column of check boxes, want those that are unchecked).

I tried a variety of versions of this, but this error message "Incorrect Argument Set" seems to be the best error message (ha!) so I am posting this version for suggestions.

Ideas? Thanks in advance.

Find more posts tagged with

Formulas

Accepted answers

Paul Newcome

Try this:

=COUNTIFS({Protocol #}, CONTAINS("2009", @cell), {Amendment}, @cell <> 1)

All comments

Paul Newcome

Try this:

=COUNTIFS({Protocol #}, CONTAINS("2009", @cell), {Amendment}, @cell <> 1)

UserAHC

That works! Thank you for this speedy and helpful response!

Paul Newcome

Happy to help. 👍️

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.