I'm trying to count instances of a specific selection in a multi-select column when "Yes" is in another column. I've tried various FIND, COUNT, COUNTIF, COUNTIFS then IF or AND, but I'm not able to figure this one out.
This one ALMOST works, but it won't count when another value is selected in the multi-select:
=COUNTIFS({Range}, "Board", {Range}, "Yes")
Any ideas?
Thanks!