COUNTIFS + FIND FORMULA

Hi I need help with the below formula please?

I would like to return values that have Triage, ARB Approval, Business Case, FinRev Approval and CIC Approval selected

=COUNTIFS({Tech Lead}, FIND(Metric@row , @cell ) > 0, {Intake Status}, FIND("Triage, ARB Approval Buisness Case FinRev Approval CIC Approval", @cell ) > 0)

Thanks

Find more posts tagged with

Countif

Accepted answers

All comments

jjg279

Karl, are those values (Triage ARB Approval etc…) dropdown or text in a longer string? If the former I think if you get rid of your "FIND" functions it should work.

Naeem Ejaz

Try this:

Karl86

@jjg279 These are drop down fields

jjg279

Hey Karl, is something like this what you are after? This should count rows where {Tech Lead} is equal to the value in the Metric row where the formula is placed and any row where {Intake Status} is one of the items from your list.

=COUNTIFS({Tech Lead}, Metric@row , {Intake Status}, OR(CONTAINS("Triage", column@row ), CONTAINS("ARB Approval", column@row ), CONTAINS("Buisness Case", column@row) , CONTAINS("FinRev Approval", column@row ), CONTAINS("CIC Approval", column@row )))

jjg279

@Karl86 - I suspect you have this sorted by now, but was playing with a similar problem today and realized the above is more complicated than it needs to be. I believe this should work as well:

=COUNTIFS({Tech Lead}, Metric@row , {Intake Status}, OR(@cell ="Triage", @cell ="ARB Approval", @cell ="Buisness Case", @cell ="FinRev Approval", @cell ="CIC Approval"))

Assuming your dropdown column isn't a multi-select. Hope you have a great weekend!

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.