COUNTIF CONTAINS(OR(
Comments
-
Kim - I'm thinking you might need to use the HAS function. That's new with the multi-select column feature. Maybe...there isn't alot of information out there about how to count this new column type. Or maybe COUNTM? Not totally sure your unique situation.
However, I have a COUNTIFS situation with a multi-select column that I can't figure out. I have a sheet with a list of project impacts and the corresponding audience that is impacted by this change. I have an intra-sheet formula that determines if something is entered in the Impact? column and returns a Y or N. I want to write a formula using the multi-select column that answers the question:
"How many times in this specific audience impacted?"
And I want it to count the number of times an audience is selected AND there is a Y in my Impact column. I hope the screen shots help.
I'm thinking this needs to be some kind of nested formula with COUNTIFS and HAS, but I cannot figure it out.
Help Article Resources
Categories
Check out the Formula Handbook template!