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:

Best Answer

  • Heather Duff
    Heather Duff ✭✭✭✭✭✭
    Answer ✓

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