Summarize by several columns

Hi guys! I'm struggling to find a way to summarize my table that has some identical rows into the sum of those duplicate rows. I will upload a file and also a picture.
I would not mind if the solution is a VBA based one.
Thank you a lot!

excelforum-summarize.PNG

Using Power Query.

Mcode

Please Login or Register  to view this content.

Originally Posted by day92

How about something like this...

Thank you for your answer, unfortunately I cannot use your solution because it is based on the second table that I do not have. I need to extract the second table from the first (and only one) table.

Try in K3

=IFERROR(LOOKUP(2,1/(COUNTIFS($K$2:$K2,$B$3:$B$13,$L$2:$L2,$C$3:$C$13,$M$2:$M2,$D$3:$D$13,$N$2:$N2,$E$3:$E$13,$O$2:$O2,$F$3:$F$13)=0),B$3:B$13),"")

Copy down and across till Col O and then in Col R

In P3

=IF(K3="","",SUMIFS(G:G,$B:$B,$K3,$C:$C,$L3,$D:$D,$M3,$E:$E,$N3,$F:$F,$O3))

Copy down and across till Col Q

summarize-by-several-columns-sample.xlsx

Originally Posted by alansidman

Using Power Query.

Mcode

Please Login or Register  to view this content.

Thank you very much Alan. I haven't used Power Query before but your answer looks like what I need, so better later than never. Thanks again!

Originally Posted by Ace_XL

Try in K3

=IFERROR(LOOKUP(2,1/(COUNTIFS($K$2:$K2,$B$3:$B$13,$L$2:$L2,$C$3:$C$13,$M$2:$M2,$D$3:$D$13,$N$2:$N2,$E$3:$E$13,$O$2:$O2,$F$3:$F$13)=0),B$3:B$13),"")

Copy down and across till Col O and then in Col R

In P3

=IF(K3="","",SUMIFS(G:G,$B:$B,$K3,$C:$C,$L3,$D:$D,$M3,$E:$E,$N3,$F:$F,$O3))

Copy down and across till Col Q

Attachment 655144

Yes Ace_XL, your solution looks good also. Thank you very much. I'll need to decide what solution I should use, because my table has over 60k rows.

Originally Posted by day92

How about something like this...

day92
Sorry for off-topic interjection:

Although there is no official rule regarding this behavior, we request that wherever possible both the question AND the answer be provided in substantive detail here within the thread. An attached workbook is an excellent aid for posing a question and offering a solution, but solely doing that with no in thread explanation makes it difficult for researchers to understand or consider the Q & A of this thread without downloading what may be a pointless doc to them, if they can do that at all. Doing that also hides the content from search engines so others may never benefit from this.

I'm sure you understand, and we look forward to seeing you post your formulas/macros in your posts for the searching benefit of all.

Thanks again for all your hard work here!