I'm currently using a CSE formula to retrieve the total number of
different criteria within a data source using the following:

{=SUM(COUNTIF(data.range,{"criteria1","criteria2", "etc"}))}

What I want to do is now sum the values of those items that are not of
those values i.e.

{=SUM(COUNTIF(data.range,{<"criteria1",<"criteri a2",<"etc"}))}

Is this possible and if yes, how do I go about doing it.