No apology needed, I suggested that you probably should start a new thread because you'll likely get more responses from different contributors.

As you can see in my sample in Post #8, the formula does not require the extra brackets/parenthesis, and I don't know why your Excel won't accept the formula without them. (It doesn't hurt, but it doesn't need them)

The SUM function is required in order to produce the correct results, we're using COUNTIF to count __2__ variations of the words "Xerox" and "Color", in this order, or reversed, with wildcards in front, middle, and end. These 2 different conditions are housed within the curly braces { } as an OR operator, it's telling COUNTIF to count This OR That. The COUNTIF actually produced 2 results (4, and 2 for this sample), the SUM adds them together to give the total of 6.

If you select the COUNTIF portion of the formula in the formula bar, then hit F9, you'll see what I mean, or you can use "Evaluate Formula" in "Formulas" ribbon to go thru the formula.