+ Reply to Thread
Results 1 to 7 of 7

Vlookup to add Quantities and Dollar Amount Sold

  1. 07-18-2018, 04:59 PM #1
    Fredbugatti
    Fredbugatti is offline
    Forum Contributor
    Join Date
    05-09-2014
    MS-Off Ver
    Excel 2017
    Posts
    300

    Vlookup to add Quantities and Dollar Amount Sold

    We need a formula to add up the matching UPCS from sheet 1 to sheet 2 of the item and return the quantity sold and the dollar amount.
    Please see attached for example.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 07-18-2018, 05:38 PM #2
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,939

    Re: Vlookup to add Quantities and Dollar Amount Sold

    Please update your profile as necessary to properly reflect the exact version(s) of Excel your question relates to. Members tailor answers based on your Excel version. Your profile says 2003, but your file indicates at least 2007
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
  3. 07-18-2018, 05:40 PM #3
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,939

    Re: Vlookup to add Quantities and Dollar Amount Sold

    Which way is this going?
    Does sheet1 feed sheet2 or does sheet2 feed sheet?
    Reply With QuoteRegister To Reply
  4. 07-18-2018, 05:56 PM #4
    Fredbugatti
    Fredbugatti is offline
    Forum Contributor
    Join Date
    05-09-2014
    MS-Off Ver
    Excel 2017
    Posts
    300

    Re: Vlookup to add Quantities and Dollar Amount Sold

    The version is 2007 and Sheet 2 feeds sheet 1 the data
    Reply With QuoteRegister To Reply
  5. 07-18-2018, 06:04 PM #5
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,939

    Re: Vlookup to add Quantities and Dollar Amount Sold

    Quote Originally Posted by Fredbugatti View Post
    The version is 2007 ....
    Please update your profile to show that. It currently says 2003.

    Also, can you add some more (different) sample data and expected outcome?
    Reply With QuoteRegister To Reply
  6. 07-18-2018, 06:06 PM #6
    Fredbugatti
    Fredbugatti is offline
    Forum Contributor
    Join Date
    05-09-2014
    MS-Off Ver
    Excel 2017
    Posts
    300

    Re: Vlookup to add Quantities and Dollar Amount Sold

    Sure, please see attached.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  7. 07-18-2018, 06:22 PM #7
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,939

    Re: Vlookup to add Quantities and Dollar Amount Sold

    Thanks.

    QTY sold
    =SUMIF(Sheet2!$C:$C,Sheet1!$F2,Sheet2!$D:$D)
    $ sold
    =SUMPRODUCT(--(Sheet2!$C$2:$C$10=Sheet1!$F2),Sheet2!$D$2:$D$10*Sheet2!$E$2:$E$10)
    both copied down as needed.
    Adjust the range in the 2nd formula as needed, too

    Also, check your answer in H3, it is not 200
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Calculate Projected Annual amount from Dollar value (Amount) and varying time intervals
    By old dawg in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-16-2016, 07:29 PM
  2. Counting Quantities of Products Sold
    By FSOMarc in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-14-2013, 06:46 PM
  3. [SOLVED] Subtract multiple quantities sold from multiple worksheets from master inventory worksheet
    By grammydeb52 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-01-2013, 03:01 AM
  4. We want a formula that will show items sold by the day and the net amount sold on that day
    By Mark Quan in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-02-2013, 09:17 PM
  5. [SOLVED] Calculate dollar amount paid if between a to and from amount
    By oxicottin in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-21-2012, 08:01 PM
  6. Adding whole dollar amounts, then a percentage, then a partial dollar amount?
    By pede69 in forum Excel General
    Replies: 4
    Last Post: 09-14-2011, 06:23 PM
  7. index row, return dollar amount adding amount together
    By desk.doc in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-27-2007, 12:11 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1