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:

=SUMPRODUCT(--(Sheet2!A:A="JAN"),--(Sheet2!R:R=E5),--(Sheet2!I:I<>Sheet1!O:O),Sheet2!E:E)
Thanks in advance!