Try...

=SUMPRODUCT(--(A1:A10<""),(1-ISNUMBER(MATCH(A1:A10,{"Criteria1","Criteri
a2","Criteria3"},0))))

By the way, your first formula...

=COUNTIF(A1:A10,{"Criteria1","Criteria2","Criteria 3"})

....does not need to be confirmed with CONTROL+SHIFT+ENTER. You only
need to confirm with ENTER.

Hope this helps!

In article . com,
"Santa-D" wrote:

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.