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)