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:

sport=formula-one&utm_source=INTERNAL&utm_medium=LINK&utm_content=MOTORSPORT-EDITORIAL-LINK&utm_campaign=ACQUISITION

<colgroup><col></colgroup><tbody>
</tbody>

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.