You cannot negated cell references
Also the size of each array must be the same
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"ocuhcs" wrote in message
...
I have a sumproduct formula that i am trying to sum all cells in arow that
are not already included in my formula. I am sure this can be done by
incorporating the NOT funtion, but I do NOT know how to execute this as an
array.

Here is my attempt that returns a #value error.
=SUMPRODUCT("'Wholesale Orders'!E:E),--(=not(='Project
Forecast'!A6:A22),('Wholesale Orders'!F:F)