Help with Countifs & Contains formula

APS2011

I am trying to create a formula to count the number of orders that are on hold. However, we have several hold types, so I just need to count any order that says 'hold' in the field. Here is my current formula. Can you help me figure out why it is not working?

=COUNTIFS({Copy of Copy of LATAM Backlog Range 2}, "40 DEALER CAPITAL ORDER", {Copy of Copy of LATAM Backlog Range 2}, "40 DEALER CAPITAL ORDER", {Copy of Copy of LATAM Backlog Range 3}, "CAPEQUIP", CONTAINS({Copy of Copy of LATAM Backlog Range 4}, "Hold", @cell))

Find more posts tagged with

Formulas

Accepted answers

Paul Newcome

Your range/criteria set for CONTAINS is off a little.

=COUNTIFS(…………….., {Range}, CONTAINS("Hold", @cell))

All comments

Paul Newcome

Your range/criteria set for CONTAINS is off a little.

=COUNTIFS(…………….., {Range}, CONTAINS("Hold", @cell))

APS2011

Thank you!

Paul Newcome

Happy to help. 👍️

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.