Count if Production is anywhere in the cell.

Brandon03

PDCA range 2 is a drop down list. It is counting it if Production is the ONLY thing selected. If there are multiple things selected, it wont find it in the list and count it. Formula =COUNTIFS({PDCA Range 2}, "Production", {PDCA Range 1}, FIND("OK 3", @cell) = 0)

Genevieve P.

Hi @Brandon03

With multi-select dropdown lists, you can use the function HAS to see if the cell has this one specific entry. It looks like your Range 1 is similar, is that correct? I would suggest using HAS in both instances...try something like this:

=COUNTIFS({PDCA Range 2}, HAS(@cell, "Production"), {PDCA Range 1}, HAS(@cell, "OK 3"))

Let me know if this works!

Cheers,

Genevieve

Genevieve P.

Hi @Brandon03

With multi-select dropdown lists, you can use the function HAS to see if the cell has this one specific entry. It looks like your Range 1 is similar, is that correct? I would suggest using HAS in both instances...try something like this:

=COUNTIFS({PDCA Range 2}, HAS(@cell, "Production"), {PDCA Range 1}, HAS(@cell, "OK 3"))

Let me know if this works!

Cheers,

Genevieve