Help on formula

Mohamed Ali

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:

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))

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.