efficient way to sum numbers of repeated rows?
Results 1 to 6 of 6

Thread: efficient way to sum numbers of repeated rows?

  1. #1
    New Member
    Join Date
    Aug 2019
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default efficient way to sum numbers of repeated rows?

    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.


  2. #2
    Board Regular sandy666's Avatar
    Join Date
    Oct 2015
    Posts
    2,679
    Post Thanks / Like
    Mentioned
    27 Post(s)
    Tagged
    1 Thread(s)

    Cool Re: efficient way to sum numbers of repeated rows?

    something like this?

    NAME Points In Certain Category Sum
    JACK
    173
    MIKE
    87
    LENNON
    74
    PAUL
    82
    ROD
    61
    TOTAL
    72
    I know you know but I forgot my Crystal Ball and don't know what you know



    In the first post, show the type of machine (PC / Mac) and the Office version you are working on
    impossible things we do on the spot. for miracles you need to wait for a while

  3. #3
    MrExcel MVP Rick Rothstein's Avatar
    Join Date
    Apr 2011
    Location
    New Jersey, USA
    Posts
    35,116
    Post Thanks / Like
    Mentioned
    92 Post(s)
    Tagged
    33 Thread(s)

    Default Re: efficient way to sum numbers of repeated rows?

    Quote Originally Posted by trati0n View Post
    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)?
    Rick's "mini" blog... http://www.excelfox.com/forum/f22/
    .
    Want to post a small screen shot? See Part B here.

  4. #4
    New Member
    Join Date
    Aug 2019
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: efficient way to sum numbers of repeated rows?

    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)


  5. #5
    Board Regular sandy666's Avatar
    Join Date
    Oct 2015
    Posts
    2,679
    Post Thanks / Like
    Mentioned
    27 Post(s)
    Tagged
    1 Thread(s)

    Cool Re: efficient way to sum numbers of repeated rows?

    show expected result in a table form not a picture
    I know you know but I forgot my Crystal Ball and don't know what you know



    In the first post, show the type of machine (PC / Mac) and the Office version you are working on
    impossible things we do on the spot. for miracles you need to wait for a while

  6. #6
    Board Regular sandy666's Avatar
    Join Date
    Oct 2015
    Posts
    2,679
    Post Thanks / Like
    Mentioned
    27 Post(s)
    Tagged
    1 Thread(s)

    Cool Re: efficient way to sum numbers of repeated rows?

    maybe

    NAME Points in certain Category SUM
    JACK
    82
    MIKE
    51
    LENNON
    38
    PAUL
    47
    ROD
    29
    TOTAL
    247

    Code:
    
    // 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
    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
    Last edited by sandy666; Aug 11th, 2019 at 04:45 PM.
    I know you know but I forgot my Crystal Ball and don't know what you know



    In the first post, show the type of machine (PC / Mac) and the Office version you are working on
    impossible things we do on the spot. for miracles you need to wait for a while

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •