SUMPRODUCT - How can I use does not equal in an array?

[DG]

I am trying to say in an array "does not Equal".

I want it to be everything other than "red" for example.

 

[Bob Phillips]

<>"red"

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[DG]

Thanks Bob. Brainfreeze on my part.

<>"red"

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Bob Phillips]

We all get those <g>

Regards

Bob

Thanks Bob. Brainfreeze on my part.