Results 1 to 4 of 4

Sum multiple values that correspond to my LOOKUPVALUE.

Threaded View

  1. #1
    Registered User
    Join Date
    06-06-2013
    Location
    Louisville, Kentucky (U.S)
    MS-Off Ver
    Excel 2010
    Posts
    3

    Sum multiple values that correspond to my LOOKUPVALUE.

    I am trying to use Sum a VLOOKUP where Table has multiple values that = the ONE lOOKUPVALUE.

    This is a very complex spreadsheet but I simplified the results in an easy to ready simple spreadsheet.

    Please see attached document.

    Any help is greatly appreciated!

    Have a wonderful day.

    For Example...

    A company has multiple products.
    Each product has 1 sales amount.
    Using the Company as my Lookupvalue I need to sum all the Product sales amounts that correspond with that company.

    Example File.xlsx
    Last edited by JBeaucaire; 06-06-2013 at 06:16 PM. Reason: Corrected Title, as per forum rules. Please take a moment to read the Forum Rules, link is above in the meny bar.

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