Posted to microsoft.public.excel.worksheet.functions

Posts: n/a

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

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

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
SUMPRODUCT as array formula?	Henrik	Excel Worksheet Functions	2	November 2nd 05 07:08 AM
Sumproduct + Array Function?	Darren Hill	Excel Worksheet Functions	4	September 8th 05 01:47 PM
What cells in a array equal my value?	Stephen	Excel Worksheet Functions	10	July 20th 05 08:59 PM
Another SUMPRODUCT array anomaly	Jerry W. Lewis	Excel Worksheet Functions	6	May 13th 05 06:42 PM
Changing a range of an array in a SUMPRODUCT formula gives a #N/A error	Chrism	Excel Discussion (Misc queries)	4	May 4th 05 04:06 PM

All times are GMT +1. The time now is 09:43 AM.

About Us

"It's about Microsoft Excel"