+ Reply to Thread
Results 1 to 4 of 4

Add similar name amounts

  1. #1
    Registered User
    Join Date
    11-05-2007
    Posts
    8

    Question Add similar name amounts

    Hi all,

    I have a spreadsheet with 2 workbooks, one the first book I have a column with a long list of names and 2nd column with different amounts next to each name. A name will repeat several times and I need to add all the amounts belonging to each name and show in a table in another workbook.

    here's an example:

    Please Login or Register  to view this content.
    So basically what I'm looking for is to create a separate table on another workbook and have Excel list each name in that column only once, and in the next cell show a "total" amount for each person. So for example Jonathan would be listed with 40, George with 110

    Thanks in advance if you can help!

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    21,528

    Re: Add similar name amounts

    Use a Pivot Table - set Name as Row Field (label pending version) and set Amount as Data Field.

    General intro. link to Pivots in my sig.

  3. #3
    Forum Moderator dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Smile Re: Add similar name amounts

    Good afternoon georgei
    Quote Originally Posted by georgei View Post
    So basically what I'm looking for is to create a separate table on another workbook and have Excel list each name in that column only once, and in the next cell show a "total" amount for each person. So for example Jonathan would be listed with 40, George with 110
    What you need to use is a pivot table (Data > Pivot table and pivot chart report). I can't really explain how they work here, but I suggest you don't look at the online help but just dive in and see how you go.

    If you really need some instruction you might like to have a look at Jon Peltier's introduction to pivot tables here.

    HTH

    DominicB
    Please familiarise yourself with the rules before posting. You can find them here.

  4. #4
    Registered User
    Join Date
    11-05-2007
    Posts
    8

    Re: Add similar name amounts

    I tried creating a Pivot Table, but couldn't figure it out.
    I tried selecting a range that include the column headings, and without the headings row, but I still get this error...
    "The PivotTable field name is not valid. To create a PivotTable report, you must use data that is organized as a list with labeled columns."

    My spreadsheet goes from A to V columns, name is in A and amount column is V, the last one. There are some empty columns in between, but I need them there.

    Is there anything else I can try?

+ 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