COUNTIFS multiple criteria, non-mutually exclusive

[MBarden89]

I'm trying to determine a unique number of occurences for particular keywords in a string as follows:

[TABLE="width: 2047"]
<colgroup><col></colgroup><tbody>[TR]
[TD]sport=formula-one&utm_source=INTERNAL&utm_medium=LINK&utm_content=MOTORSPORT-EDITORIAL-LINK&utm_campaign=ACQUISITION[/TD]
[/TR]
</tbody>[/TABLE]

I want to count the cells that contain motorsport but do not contain formula-one. Some cells contain both keywords, so is there a way to order the preference of COUNTIFS arguments to basically say "Look for value #1 , if it's not there look for value #2 , etc.?" - the issue I'm having, is that the formula I'm using is counting both motorsport and formula-one​. Hoping there's a way to exclude them.

Thanks in advance.

 

[Chrisdontm]

You could count all the ones that contain “formula-one” minus all the ones that contain both.