counting from a multi select cell

Kyle Black

I do not have clue where to start with this formula

I working on a behavior observation and i want to count the number of behaviors observed.

Problem is countif({column 1}, "PPE")

won't work if it is not first in the cell on a multi selected drop down cell.

any help is welcome

I will also need to be able to count the behavior and a department as well for another formula

Paul Newcome

Try a CONTAINS function.

=COUNTIFS({column 1}, CONTAINS("PPE", @cell))