How to use COUNTIFS for different text strings within one column?

Hello,

I can't figure out how to COUNT different text strings in one column.

COUNT how often "ABC" is in the TaskName column (=primary column) with its status "Green" (symbol) in the Status column AND COUNT how often is "Prot DEF" in the TaskName column AND COUNT how often is "KL" in the TaskName column all with its status "Green" in the Status column (IF). "Prot DEF" cells may also contain more text: eg. "Prot DEF 12.0", "Prot DEF 3.4".

=COUNTIFS([Task Name]:[Task Name], FIND("CSR", @cell, "Prot DEF", @cell, "KL", @cell), Status:Status, "Green") - this is not working!

Any help is much appreciated!!

Find more posts tagged with

Accepted answers

All comments

David Joyeuse

Hi @Kirsten

I'm not sure what you're trying to do here.

Do you want to return 3 different counts (1 for each string) in one cell? Or do you want to return 1 count of all those 3 strings?

Kirsten

Hello David,

Thanks for reaching out!

I want to count all the text strings ('ABC', 'Prot DEF', 'KL') that are in the green status. I may have 2 times 'ABC' in green, 1 'KL' in green, and 'Prot DEF' in red = 3 counts.

Does this make more sense?

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.