I want to count the number of occurrences where a cell value does NOT contain a value from a pre-defined array.
Audi BMW Audi Mercedes Ford BMW Ford
So with my data the expected result would be 3. I'm using
COUNTIFS because there will be multiple checks in my final formula.
I checked here, but that returns true/false for each item, which I don't need.