CountIF to look for a partial piece of text

Hi all,

I'm looking to use Count IF to look for piece of a text from a different sheet.

I've tried the following variations with no luck:

=COUNTIFS({QA WORKLOAD Date}, "BACKLOG", {QA WORKLOAD Com/CT}, "COM", {QA WORKLOAD WO ST}, "99", {QA WORKLOAD Description}, CONTAINS("SUB", @cell}))

=COUNTIFS({QA WORKLOAD Date}, "BACKLOG", {QA WORKLOAD Com/CT}, "COM", {QA WORKLOAD WO ST}, "99", {QA WORKLOAD Description}, HAS({QA WORKLOAD Description}, "Trial"))

I'm missing something, but not sure what.

Thanks,

Jack

Find more posts tagged with

Accepted answers

Michael Culley

=COUNTIFS({QA WORKLOAD Date}, "BACKLOG", {QA WORKLOAD Com/CT}, "COM", {QA WORKLOAD WO ST}, "99", {QA WORKLOAD Description}, CONTAINS("SUB", @cell}))

That one should work but you have a typo, you have a } after @cell

All comments

Michael Culley

=COUNTIFS({QA WORKLOAD Date}, "BACKLOG", {QA WORKLOAD Com/CT}, "COM", {QA WORKLOAD WO ST}, "99", {QA WORKLOAD Description}, CONTAINS("SUB", @cell}))

That one should work but you have a typo, you have a } after @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.