COUNTIF Multiple Select Row
I am trying to count all of the instances One Value is showing up in the assigned row even if two people are assigned to the same row. This is the equation I came up with but I keep getting zero even though there is actually one with that value combined with another value. What am I doing wrong?
=COUNTIFS({Project Oversight Range 5}, (CONTAINS("Mike Buckiewicz", @cell)))
A variation of this equation worked to count if there was one selection only in the column but is not calculating when there are multiple.
Please help!
Best Answer
-
You may want to try the HAS function instead of CONTAINS. It should work with multi-select dropdown and multi-contact columns. Maybe something like:
=COUNTIFS({Project Oversight Range 5}, (HAS(@cell, "Mike Buckiewicz"))
Answers
-
You may want to try the HAS function instead of CONTAINS. It should work with multi-select dropdown and multi-contact columns. Maybe something like:
=COUNTIFS({Project Oversight Range 5}, (HAS(@cell, "Mike Buckiewicz"))
-
Yes this is it! I am still learning functions so will add HAS to my arsenal!
Help Article Resources
Categories
Check out the Formula Handbook template!