How to remove duplicates in SUMIFS criteria list by an array formula|General Excel Questions & Answers|Excel Forum|My Online Training Hub

Hi all,

I am using SUMIFS to get the sum of a list of products and then using sumproduct to sum them up. The criteria is an array of product codes. Now the list of product codes has duplicate values.

I know I can just remove duplicate manually. But to get my formula to advanced level, I want to remove duplicates by an array formula inside SUMIFS.

My formula is =SUMPRODUCT(SUMIFS($I$9:$I$62306,$AQ$9:$AQ$62306,'Int SKU LIST'!$A$241:$A$279,$AR$9:$AR$62306,"1050"))

The blocked part is the list of product codes. 

Any suggestion will be helpful

Regards,

Abrar