SUMPRODUCT using not equal (it wont let me type the symbol) instead of =

[tarynmahon]

How do you use the <> in a SUMPRODUCT please, I thought I could just replace the = with <> but it's not returning the correct result. Please see example

=SUMPRODUCT(--('[LIS New Sales.xlsx]Jan12'!$C:$C="N"),--('[LIS New Sales.xlsx]Jan12'!$O:$O="INTERNET")+--('[LIS New Sales.xlsx]Jan12'!$O:$O="AGGREGATOR"))


This works fine but I actually need it to return;


=SUMPRODUCT(--('[LIS New Sales.xlsx]Jan12'!$C:$C="N"),--('[LIS New Sales.xlsx]Jan12'!$O:$O<>"INTERNET")+--('[LIS New Sales.xlsx]Jan12'!$O:$O<>"AGGREGATOR"))


This doesnt work

Any help would be greatly appreciated

 

[tarynmahon]

Dont worry, figured it out, I had to use the * instead of the +