efficient way to sum numbers of repeated rows?

trati0n

New Member
Joined
Aug 11, 2019
Messages
2
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.

QiqgVqs.jpg
 

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.
something like this?

NAMEPoints In Certain Category Sum
JACK
173​
MIKE
87​
LENNON
74​
PAUL
82​
ROD
61​
TOTAL
72​
 
Upvote 0
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)?
 
Upvote 0
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)

PooGVZ2.jpg
 
Upvote 0
maybe

NAMEPoints in certain Category SUM
JACK
82​
MIKE
51​
LENNON
38​
PAUL
47​
ROD
29​
TOTAL
247​
Code:
[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 :devilish:
 
Last edited:
Upvote 0

Forum statistics

Threads
1,213,522
Messages
6,114,112
Members
448,549
Latest member
brianhfield

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top