COUNTIF and CONTAINS and OR
I have 2 columns that have multiple select drop down options. I want to create a formula that allows me to identify a PLO and then count the number of times "BE" OR "BC" OR "BL" or "BM" appear throughout the entire sheet.
=COUNTIF([PLO Alignment]:[PLO Alignment], CONTAINS("A.1 Environment",@cell), Sections:Sections, CONTAINS("BE",@cell))
will identify the PLO A.1 Environment, and find the "BE" and count it... but how do I add the other options?
Help Article Resources
Check out the Formula Handbook template!