Using Unique,Filter & ChooseCols and to see if I can use SUMIF with it?

[Peter Davison]

I have this unique Filter and Choosecols formula below
=UNIQUE(FILTER(CHOOSECOLS('Data Import Store Product'!$D$3:$AD$100000,1,2,3,4,5,6,7,8,9,10,11),'Data Import Store Product'!$D$3:$D$100000<>""))
Is it possible to add to this formula to sum columns like 8,9,10,11 (which are values) but based on the unique criteria from Column 1 (D)

 

[Peter Davison]

Yes 4 different columns J,K,L & M (As Above) that are summed from the original file and entered in the new file as part of the unique array from my original code that sits in Cell G12
Sorry if I can't explain this very well.

 

[RoryA]

So specifically what output are you expecting for each unique row - i.e. which columns from the source data? Columns 8-11 are columns K:N not J:M, so my guess is you want unique items from D:J (cols 1 to 7) and then totals from each of the last 4 columns, so 11 columns in total?

 

[Peter Davison]

This is my source file where I want to sum Columns K to N based on the breaks in Column D

This is how I want to represent the summing in my output file based on the array formula in G12

Hope this helps
Thanks again, do appreciate your time on this.