Forum

Notifications
Clear all

How to remove duplicates in SUMIFS criteria list by an array formula

2 Posts
2 Users
0 Reactions
311 Views
(@saad_mce)
Posts: 1
New Member
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
(@catalinb)
Posts: 1937
Member Admin
 

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
Share: