+ Reply to Thread
Results 1 to 2 of 2

Sumif & Vlookup Combo?

  1. #1
    Registered User
    Join Date
    11-20-2006
    Posts
    40

    Post Sumif & Vlookup Combo?

    I have a workbook with 2 tabs.
    #1 tab contains all of the data w/ Names and dollar amounts. The Names are duplicated numerous times.
    For example:
    Smith 50.00
    Cantrell 65.00
    Smith 10.00
    Smith 5.00
    Cantrell 7.00

    #2 tab is summarizing. I have one column that states the Name - and I need the 2nd column to look up that name and list the total dollars
    For example:
    My spreadsheet looks like:
    Name: Total Dollars:
    Smith
    Cantrell

    and I need it to look like:
    Name: Total Dollars:
    Smith 67.00
    Cantrell 72.00

    I think if I could figure out a combination of Vlookup and Sumif (or maybe Sumproduct) that it would work - but I can't seem to figure it out.

    Thanks,
    aspears

  2. #2
    Registered User
    Join Date
    11-20-2006
    Posts
    40
    I figured out the solution...

    "SUMIF" is apparently all that is needed.

+ 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