Get criteria working in SUMPRODUCT

[Camel123]

Hi,

In sheet "SAP_data" column A there are costs for certain product areas.
Product area is defined in sheet "SAP_data" column B.
In sheet "Calculation" A1:A10 are product areas which I would like to exclude from the sum.

Any suggestion on how I can do this? I tried using MATCH but I only get NA-errors :/

=IF($B11="";"";IF(ISNUMBER($B11*1);SUMPRODUCT((SAP_data!A2:A222)*(--(MATCH(SAP_data!B2:B222;Calculation!A1:A10;0)=0)...

 

[jasonb75]

Perhaps

=IF($B11="";"";IF(ISNUMBER($B11*1);SUMPRODUCT((SAP_data!A2:A222)*ISNA(MATCH(SAP_data!B2:B222;Calculation!A1:A10;0))...

 

[Camel123]

Perhaps

=IF($B11="";"";IF(ISNUMBER($B11*1);SUMPRODUCT((SAP_data!A2:A222)*ISNA(MATCH(SAP_data!B2:B222;Calculation!A1:A10;0))...

Jason, thanks! Now I feel very stupid haha, it worked ofc!