CountIF w/ multi select
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?
Answers
-
Try something like this...
=COUNTIFS(Status:Status, AND(@cell <> "Complete", @cell <> "On Hold"), Location:Location, CONTAINS("Rural Hall", @cell))
-
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
Help Article Resources
Categories
Check out the Formula Handbook template!