+ Reply to Thread
Results 1 to 3 of 3

Help with Formula to Sum Product Sales based on Sales Channel and Product

  1. #1
    Registered User
    Join Date
    10-28-2015
    Location
    Kettering, England
    MS-Off Ver
    2007
    Posts
    2

    Help with Formula to Sum Product Sales based on Sales Channel and Product

    I've been asked to provide a weekly report to a non technical person with limited excel experience, the report simply needs to contain a table of product sales by each individual channel.

    My reporting software has limitations and I can only export one order per line. My problem is I don't know how to sum the quantity of each product line based on channel.

    The principal of the sum should be as follows...

    Add the numerical value in the Quantity Column IF SubSource = 'X' AND SKU = 'Y'

    My aim is to set the Print Area over the results, print them off, and pass it on to the relevant person.


    Casehype_Sales_Report_Example.xlsx

  2. #2
    Forum Expert José Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,192

    Re: Help with Formula to Sum Product Sales based on Sales Channel and Product

    Hi
    Use
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    in G2 and copy to G2:I9

  3. #3
    Registered User
    Join Date
    10-28-2015
    Location
    Kettering, England
    MS-Off Ver
    2007
    Posts
    2

    Re: Help with Formula to Sum Product Sales based on Sales Channel and Product

    Hi José

    I'm no longer at the office so don't have access to the full file but I've tested it on the sample and it seems to have worked perfectly.

    Many thanks!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] SUMIFS - Sales value only for x product in 2015
    By janagan in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-27-2015, 01:31 PM
  2. [SOLVED] Formula to List of Product Groups That Have The Most Products With Zero Sales
    By chaddug in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-23-2015, 06:12 AM
  3. Formula to check if a product is on promotion and calculate average sales
    By CA_needing_help in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-26-2015, 08:13 AM
  4. [SOLVED] Sales winners by product type
    By makinmomb in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-10-2014, 10:02 AM
  5. Product Sales to Month Sales
    By pelamis22 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 08-23-2013, 06:13 PM
  6. Formula to calculate multiple values from product sales
    By madscooter in forum Excel General
    Replies: 0
    Last Post: 06-16-2011, 12:53 PM
  7. chart for product sales
    By metalgearslug in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 06-26-2010, 09:39 PM

Tags for this Thread

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