Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
311
Views
Topic starter
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
Posted : 31/07/2019 10:57 pm
Hi Abrar,
You can try this formula, but I doubt that will work.
A formula solution is not the best idea, try Power Query.
Posted : 05/08/2019 12:55 am