SUMPRODUCT Criteria - Do Not Include Value From Separate Column

Hello Everyone,

I have a criteria issue with a sumproduct formula i'm using. The criteria is essentially supposed to say "if the value in column I (in Sheet2) equals ANY value in column O (in Sheet1), then do not include that line in the SUM. Here is the complete formula:

Please Login or Register  to view this content.

Thanks in advance!