Hi,
To exclude I assume I would use <>?
No, what I posted excludes them.

Also the =0 is important?
Yes, it's important. Instead of using a whole column, let's understand that part of the formula by using a single cell, say A1.

Starting with this:
((A1="XYZ")+(A1="CDE"))

If A1 contains either XYZ or CDE then that formula will return 1. If A1 contains neither XYZ nor CDE then the formula returns 0. So, to exclude XYZ and CDE, we equate that result to 0.

((A1="XYZ")+(A1="CDE"))=0


That's what I did in the formula, except for a whole column:

((ccs_export!$E2:$E100="XYZ")+(ccs_export!$E2:$E100="CDE"))=0