Try this...

=SUMPRODUCT(--(Data!$C$3:$C$9875=$A5),--(ISNA(MATCH(Data!$K$3:$K$9875,{"N1","N2"},0))),--(ISNUMBER(MATCH(Data!$AC$3:$AC$9875,{"c","m"},0))) )

--
Biff
Microsoft Excel MVP


"Diddy" wrote in message
...
Hi everyone,

I've been using
=SUMPRODUCT(--(Data!$C$3:$C$9875=$A5),--((Data!$K$3:$K$9875="N1")+(Data!$K$3:$K$9875="N2") ),--((Data!$AC$3:$AC$9875="c")+(Data!$AC$3:$AC$9875="m ")))
but now as part of the checking of the workbook I want a count of the
opposite where column K does not = N1 or N2.

I'm doing it the clunky way and using + every other value that K can hold
(numeric and alphanumeric) but there are a lot more of them than the N1,
N2
so it would be much neater just to be able to say neither, nor

I've tried this but it returns an unexpected number
=SUMPRODUCT(--(Data!$C$3:$C$9875=$A5),--((Data!$K$3:$K$9875<"N1")+(Data!$K$3:$K$9875<"N2 ")),--((Data!$AC$3:$AC$9875="c")+(Data!$AC$3:$AC$9875="m ")))

Where am I going wrong?

Many thanks
Diddy