Exactly - I want to sum column F if E is not equal to any of the values in
A6:A22.
I am using Excel 2003 and I have modified the forluma you posted to show
ranges of columns and not full columns.

The formula works except for the part that eliminates the entries equal to
A6:A22, it is now summing all positive values from column F (including the
rows with values = to A6:A22.

"T. Valko" wrote:

Is this what you want...

Sum column F if column E does not contain entries from A?

What version of Excel are you using? Unless you're using Excel 2007 you
can't use entire columns as range references with SUMPRODUCT.

=SUMPRODUCT(--(ISNA(MATCH('Wholesale Orders'!E1:E100,'Project
Forecast'!A6:A22,0))),'Wholesale Orders'!F1:F100)

--
Biff
Microsoft Excel MVP


"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)