Help on formula

Hello there,

I'm attempting to create a summary sheet that counts the number of times a DARCI 'Category' '& 'Status' is mentioned for a specific 'Project' and 'Product' (in this instance "DAP" - which appears in both columns) within the Source Sheet. Note that these column types for 'Project' and 'Product' are dropdown multi-selects and 'Status' is dropdown single-select.

I tried using the following formula, and although it wasn't correct, it was only applicable for the 'Project' column.

=COUNTIFS({Category}, [Primary Column]@row, CONTAINS("DAP", {Project))

Any advice?

Many thanks in advance!

Summary sheet:

Source Sheet:

Find more posts tagged with

Accepted answers

Heather Duff

Oh - I saw an error with one of the brackets in the formula. Try this, where {Product} is the named range for the Product column:

=COUNTIFS({Category}, [Primary Column]@row, {Project}, CONTAINS("DAP", @cell), {Product}, CONTAINS("DAP", @cell))

All comments

Heather Duff

Hi @Mohamed Ali ,

Try this:

=COUNTIFS({Category}, [Primary Column]@row, {Project), CONTAINS("DAP", @cell))

Let me know if it works!

Best,

Heather

Mohamed Ali

Hi @Heather D , thanks for the prompt response. Unfortunately, this didn't work. I will also highlight that the formula only searches for 'Project' but it also needs to search for 'Product' too.

Heather Duff

Oh - I saw an error with one of the brackets in the formula. Try this, where {Product} is the named range for the Product column:

=COUNTIFS({Category}, [Primary Column]@row, {Project}, CONTAINS("DAP", @cell), {Product}, CONTAINS("DAP", @cell))

Mohamed Ali

Thank you, @Heather D. Truly appreciate the speedy resolution. You're a ⭐️!!

Heather Duff

@Mohamed Ali Glad it worked for you! I'm happy to help. Have a great week.

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.