Countifs Multiple Criteria

Here's one way of several:

=SUMPRODUCT( 
    --(ccs_export!$D2:$D100="abc") , 
    --(((ccs_export!$E2:$E100="XYZ")+(ccs_export!$E2:$E100="CDE"))=0) , 
    etc..... )