COUNTIF formula with CONTAINS not working

JP Pedicino

I am having an issue when adding a "contains" function to my "countif" function. I am hoping someone can assist.

The current formula that I am using works perfectly for COUNTIF

=COUNTIF({Import RFI's Range 1}, "ADCVD")

When I convert the formula to include CONTAINS I get an INVALID ARGUMENT message.

=COUNTIF(CONTAINS({Import RFI's Range 1}, "ADCVD"))

I've tried a couple of different variations of the formula, but can't seem to get it right.

I would appreciate if anyone can assist.

Find more posts tagged with

Formulas

Accepted answers

Bassam Khalil

Hi @JP Pedicino

Hope you are fine, please try the following formula:

=COUNTIF({Import RFI's Range 1}, CONTAINS("ADCVD",@cell))

All comments

Bassam Khalil

Hi @JP Pedicino

Hope you are fine, please try the following formula:

=COUNTIF({Import RFI's Range 1}, CONTAINS("ADCVD",@cell))

JP Pedicino

Thank you so much for your assistance!

Bassam Khalil

@JP Pedicino

You are welcome and i will be happy to help you any time.

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.