How to use a COUNTIFS formula that excludes multiple criterion in Multi-Select Dropdown column?
I'm trying to count the total number of values in a Multi-Select Dropdown column when criteria in another Multi-Select Dropdown column is not present. For example, let's say I have a FRUIT column with Apple, Orange, Banana, and Kiwi values. I also have a STATUS column with Rotten, Fresh, Stolen, and Eaten values. In rows 1-6, I want to count how many times I found an Apple that was NOT Rotten. I can make it work with just one criterion excluded, but I can't find the right syntax for multiple criterion excluded. What's the best way to include multiple criterion in a NOT(CONTAINS expression? (The reason I am trying to EXCLUDE criteria is because my actual multi-select dropdown column has more than 50 values. I am trying to count occurrences in one column that excludes just a few qualifiers in another.)
Help Article Resources
Check out the Formula Handbook template!