+ Reply to Thread
Results 1 to 4 of 4

Consolidate like values and sum data

  1. #1
    Registered User
    Join Date
    06-28-2013
    Location
    Boston, MA, USA
    MS-Off Ver
    Office Mac, Excel 2010
    Posts
    2

    Consolidate like values and sum data

    Hello,

    I am having trouble finding the correct function to combine data on a spreadsheet I'm working on (attached). Essentially, I have data in column A with names, many of which occur several times throughout the column. However, each row has a specific numerical value in column B. I am trying to consolidate the data by combining rows with similar names but summing the numerical values. For example:

    Name, Value
    A, 3
    A, 2
    A, 7
    B, 4
    C, 11
    C, 6

    Becomes...

    Name, Value
    A, 12
    B, 4
    C, 17

    If someone could help me out with the function and how to complete it, that would be greatly appreciated.

    Cheers,
    chandy
    Attached Files Attached Files
    Last edited by chandy; 06-28-2013 at 10:58 AM.

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,988

    Re: Consolidate like values and sum data

    with an pivot table.
    Attached Files Attached Files
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Registered User
    Join Date
    06-28-2013
    Location
    Boston, MA, USA
    MS-Off Ver
    Office Mac, Excel 2010
    Posts
    2

    Re: Consolidate like values and sum data

    Haha such a simple solution! Thanks for your help!

  4. #4
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,988

    Re: Consolidate like values and sum data

    Thanks for the reply.

    Glad i could help.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1