COUNT that CONTAINS

HardWork

How do I create a formula that COUNTS all the submissions that CONTAIN (using the Facility column):

COUNT all that CONTAIN = DFW then provide a total count for just DFW

COUNT all that CONTAIN = EP then provide a total count for just EP

COUNT all that CONTAIN = LV then provide a total count for just LV

COUNT all that CONTAIN = OK then provide a total count for just OK

COUNT all that CONTAIN = PA then provide a total count for just PA

COUNT all that CONTAIN = SA then provide a total count for just SA

COUNT all that CONTAIN = WI then provide a total count for just WI

I want to use this on a separate SHEET for a Dashboard quick count check.

Find more posts tagged with

Accepted answers

Intern98

=COUNTIF([Column Name]:[Column Name], CONTAINS("DFW",[cell]@row))

All comments

Sameer Karkhanis

Try this:

=COUNTIF([Column Name]:[Column Name], CONTAINS("DFW",@cell)) to get all that contain DFW and just repeat the formula replacing the DFW with others.

HardWork

Hi Sameer,

This is what I put together based on your suggestion (thank you for the assistance):

but I get the #UNPARSEABLE error message. Am I missing a () somewhere?

Intern98

=COUNTIF([Column Name]:[Column Name], CONTAINS("DFW",[cell]@row))

Andrée Starå

Hi @HardWork

I hope you're well and safe!

Try something like this.

=COUNTIF({QA LEAD EVALUATION (WITH FORM) Range 1}, CONTAINS ("DFW", @cell)

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

HardWork

That one worked. Thank you very much for your assistance!

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