Hi!

Your formula does not need to be CSE entered.

Maybe something like this: (depends on details that were not provided)

=ABS(COUNTA(A1:B5)-SUM(COUNTIF(A1:B5,{"a","b","c"})))

Biff

"Santa-D" wrote in message
ups.com...
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.