counting multiple select column

Gil Levit

Hello,

I have a project plan that I'm trying to report on. I have a column for health check and a column for assigned team.

I want to see a total count of each status per team. That is the easy part and I figured that out by doing a

=COUNTIFS({HealthCheck}, "Red", {Team}, OR(@cell = "FI", @cell = "FIT"))

My issue is that it will only count if there is one team in the team column. If I have multiple teams such as FI, FIT the formula above won't count it.

How do I tell the formula to count if a value appears anywhere in a cell not exactly equal to that cell?

Leibel S

Your criteria should be the HAS function.

Something like the below:

=COUNTIFS({HealthCheck}, "Red", {Team}, OR(HAS(@cell, "FI"), HAS(@cell, "FIT")))

Leibel S

Your criteria should be the HAS function.

Something like the below:

=COUNTIFS({HealthCheck}, "Red", {Team}, OR(HAS(@cell, "FI"), HAS(@cell, "FIT")))

Gil Levit

Thank you Leibel S....this is great!