CountIF w/ multi select

Kevin Greco

I'm trying to create a formula to count the number of rows containing a specific location where the location column is a multi select. Also, part of that formula needs to only account for that location in an "Open" status. So far I've been able to make the formula work to disregard anything that is "Complete" or "On Hold". I've been messing around with adding a CONTAINS or a FIND to the formula for gathering that specific location data, but I'm not coming up with anything that works. For example, how would I write this formula to find how many rows contain "Rural Hall" and are not under a Complete or On Hold status?

Paul Newcome

Try something like this...

=COUNTIFS(Status:Status, AND(@cell <> "Complete", @cell <> "On Hold"), Location:Location, CONTAINS("Rural Hall", @cell))

Sean Morgan

Hello @Kevin Greco ,

You may want to use something like this: =COUNTIFS(Status:Status, <>"Complete", Status:Status, <>"On Hold", Values:Values, CONTAINS("Rural Hall", @cell))

See the results in my below screenshot:

Kindest Regards

Sean