Cell has multiple data?

Morris R

Hello,

Hoping someone could help with a simple formula from another sheet that has multiple drop downs?

=COUNTIF({DATA COLUMN}, HAS(@cell, "ICM" + "PCM"))

I want to count how many times "ICM" and "PCM" appear together in a drop down cell from another sheet. They could be selected individually which i dont need just when they occur together.

Thank you

bisaacs

Hey @Morris R,

I would try wrapping the HAS function in an OR statement and see if that works:

=COUNTIF({DATA COLUMN}, OR(HAS(@cell, "ICM"), HAS(@cell, "PCM")))

See if that works!

Morris R

Thank you

I didn't work and tried some variations

Morris R

Sorry typo

Formula DIDN'T work

apologies