+ Reply to Thread
Results 1 to 8 of 8

Show the total sales for each year for specific Product Name.

  1. #1
    Registered User
    Join Date
    11-14-2012
    Location
    England
    MS-Off Ver
    Excel 2003
    Posts
    2

    Show the total sales for each year for specific Product Name.

    Hi There,

    I am an intermediate user of Excel and need some help with automated a task I need to do.

    What I have is two sets of data. Set one columns are:

    Product Name, 2008, 2009, 2010, 2011, 2012

    Product Name example is "Spherical 500"

    Set two is as follows;

    Product, 2008, 2009, 2010, 2011, 2012 - Approx 4600 Records

    Product Example is "NSHBA-BL-00001 Basics 114mm x 1200mm Bollard Root Fixed Bollard Galvanised"

    The ultimate result I want is to show the total sales for each year for "Product Name". What I need to do is search the data for a match to "Product Name" e.g. Spherical 500. Where there is a match sum the sales for all the matches and return the value in the first set of data.


    So in simple terms - Look at Value in Product Name, Look for all matches in second set of data, where there is a match or multilple matches, sum those numbers. I will need to do this for each year.

    Can anyone help?
    Last edited by jeffreybrown; 11-14-2012 at 11:14 AM.

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Excel 2007
    Posts
    19,643

    Re: Help with a Formula please...

    I would suggest that you change your title, before the moderators force you to - take a look at the forum rules at the top of the screen.

    Pete

  3. #3
    Registered User
    Join Date
    11-14-2012
    Location
    England
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Help with a Formula please...

    To be honest Pete, I dont really know what formula I am looking for hence I don't know how to phrase the question.

    Also, where are the amend thread tools? can't put my finger on them.

    Thanks

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    49,980

    Re: Help with a Formula please...

    To change a Title on your post, click EDIT (of you're 1st post) then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
    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

  5. #5
    Forum Expert Kevin UK's Avatar
    Join Date
    12-07-2010
    Location
    Radstock, Somerset
    MS-Off Ver
    Excel 2003,2007,2010,2013
    Posts
    1,914

    Re: Help with a Formula please...

    Sum function to match criteria, something along those lines!

  6. #6
    Registered User
    Join Date
    04-11-2011
    Location
    Texas
    MS-Off Ver
    Office 2007
    Posts
    78

    Re: Show the total sales for each year for specific Product Name.

    First, to change the post title or information or add a worksheet (which always helps whomever wants to answer your question) click the 'Edit Post' button on your original post.

    Second, it sounds like SUMIF() or SUMIFS() will get you where you need to be, unless I'm not understanding your question. I may not understand the full scope of what you want so please add a worksheet if that's the case.

  7. #7
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2019
    Posts
    18,236

    Re: Show the total sales for each year for specific Product Name.


  8. #8
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    10,052

    Re: Show the total sales for each year for specific Product Name.

    Your profile shows 2003, and if this is the case then...

    =SUMPRODUCT(--($A$2:$A$10=2009),--($B$2:$B$10="Speherical 500"),$C$2:$C$10)

    ...if you do have 2007+

    =SUMIFS($C$2:$C$10,$A$2:$A$10,2009,B2:B10,"Speherical 500")
    HTH
    Regards, Jeff

+ 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