+ Reply to Thread
Results 1 to 3 of 3

Combining data from two tables

  1. #1
    Registered User
    Join Date
    01-29-2008
    Posts
    5

    Combining data from two tables

    I need to add data from a partial list to an existing table.

    So for example, if this is my full list


    Apple 5
    Barry 9
    Cherry 4
    Dog 7
    Eagle 2
    Fire 6

    And this is my partial list

    Apple 5
    Cherry 6
    Fire 3


    How do I create a brand new table with summed data?


    Apple 10
    Barry 9
    Cherry 10
    Dog 7
    Eagle 2
    Fire 9

    Thanks very much in advance,

    Chris

  2. #2
    Registered User
    Join Date
    11-20-2007
    Posts
    32
    you could do something like this with a simple sumif - see attached file for demonstration,
    Regards,
    Tom
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    01-29-2008
    Posts
    5
    thanks so much this is perfect

+ 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