countifs multiple drop down menu selections

OGradyjr

Hello,

I am trying to use countifs to see how many Priority types do not have an Approval and have a specific Inventory Org. The issue I am coming across is if there are multiple selections under the Inventory Org dropdown-multi select column.

Have tried to use CONTAINS and HAS nested into COUNTIFS without success. Any recommendations?

Thank you!

Mike TV

@OGradyjr

Maybe showing you this formula working will help you to get yours working?

Formula:

=COUNTIF([Column4]:[Column4], CONTAINS("Gary", @cell))

If not, could you please copy/paste your non-working formula into this thread and we can possibly help you troubleshoot it. CONTAINS searches for a piece of information. HAS will need an exact match.

OGradyjr

@Mike TV , unfortunately that isn't working.

Current formula: =COUNTIFS({Inventory org}, CONTAINS("BGM", {Inventory org}), {Priority1}, [Primary Column]@row, {Approval}, "")

This formula works for all single selects from the Dropdown-Multiple Select Inventory Org column.

Mike TV

@OGradyjr

=COUNTIFS({Inventory org}, CONTAINS("BGM", @cell), {Priority1}, [Primary Column]@row, {Approval}, "")

Does this work?