efficient way to sum numbers of repeated rows?

[trati0n]

hey guys, basically the title said it all. I have one excel file, that contains the sum of lots of files, they were all the same format, rows and columns, but with different values,it's cool that with a macro I have been able to put them all in the same sheet, but I don't know where can I go from there. Is there any trick to simplify all that information? I have search a lot, but I didn't find a way to merge those columns and sum the numbers.

 

[sandy666]

something like this?

[Table="width:, class:head"]
[tr=bgcolor:#FFFFFF][td=bgcolor:#70AD47]NAME[/td][td=bgcolor:#70AD47]Points In Certain Category Sum[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]JACK[/td][td=bgcolor:#E2EFDA]

173​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]MIKE[/td][td]

87​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]LENNON[/td][td=bgcolor:#E2EFDA]

74​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]PAUL[/td][td]

82​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]ROD[/td][td=bgcolor:#E2EFDA]

61​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]TOTAL[/td][td]

72​

[/td][/tr]
[/table]

 

[Rick Rothstein]

but I didn't find a way to merge those columns and sum the numbers.

What are you looking for a a final answer? Can you show us the output you would want for the example you posted (using the numbers you posted so we can see what you added and where it ended up)?

 

[trati0n]

thanks for taking the time to read and answer guys, sorry if I wasn't clear enough. And I have to add, that the total was wrong, it should be the sum of all the column. But the idea is this,to get the sum in just one of this, instead of various (as shown in my original message)

 

[sandy666]

show expected result in a table form not a picture

 

[sandy666]

maybe

[Table="width:, class:head"]
[tr=bgcolor:#FFFFFF][td=bgcolor:#70AD47]NAME[/td][td=bgcolor:#70AD47]Points in certain Category SUM[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]JACK[/td][td=bgcolor:#E2EFDA]

82​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]MIKE[/td][td]

51​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]LENNON[/td][td=bgcolor:#E2EFDA]

38​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]PAUL[/td][td]

47​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]ROD[/td][td=bgcolor:#E2EFDA]

29​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]TOTAL[/td][td]

247​

[/td][/tr]
[/table]

[SIZE=1]
// Query1
let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    Group = Table.Group(Table.UnpivotOtherColumns(Source, {"NAME"}, "Attribute", "Value"), {"NAME"}, {{"Points in certain Category SUM", each List.Sum([Value]), type number}})
in
    Group[/SIZE]

and this is NOT vba but M-code and PowerQuery

next time show proper source data AND expected result in a table form (not a picture)
I don't want to waste my time