+ Reply to Thread
Results 1 to 5 of 5

multiple column sum product based on set criteria

  1. #1
    Registered User
    Join Date
    03-12-2010
    Location
    North Lincolnshire, England
    MS-Off Ver
    Excel 2007
    Posts
    36

    multiple column sum product based on set criteria

    Morning all

    I have an array of information that i have to crunch daily and i would olike to speed the process up by creating a table i can upload the data to on a day by day basis that will auto generate the results i want please. Basically i require a total weight by type split by shift in order to see how each shift is performing on each type of product required.

    I have created a basic mock up of the data and the result i hope to achieve which should explain far easier than trying to in words hopefully.

    Thank you in advance

    Damion
    Attached Files Attached Files

  2. #2
    Forum Guru (RIP) Marcol's Avatar
    Join Date
    12-23-2009
    Location
    Fife, Scotland
    MS-Off Ver
    Excel '97 & 2003/7
    Posts
    7,216

    Re: multiple column sum product based on set criteria

    Try this in I4
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Drag Across to Q4, then Down as required.
    If you need any more information, please feel free to ask.

    However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....

    Also
    اس کی مدد کرتا ہے اگر
    شکریہ کہنے کے لئے سٹار کلک کریں
    If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.

  3. #3
    Registered User
    Join Date
    03-12-2010
    Location
    North Lincolnshire, England
    MS-Off Ver
    Excel 2007
    Posts
    36

    Re: multiple column sum product based on set criteria

    Thank you Marcol

    I had just worked out the same formula but in a different order so sorry for wasting your time

    my solution =SUMPRODUCT((($D$4:$D$21=I3)*($E$4:$E$21))*($C$4:$C$21=$H$4))

    kind regards

    Damion

  4. #4
    Forum Guru (RIP) Marcol's Avatar
    Join Date
    12-23-2009
    Location
    Fife, Scotland
    MS-Off Ver
    Excel '97 & 2003/7
    Posts
    7,216

    Re: multiple column sum product based on set criteria

    No problem.
    Also note the multiplier/syntax differences, no matter however, the result is the same ...

  5. #5
    Registered User
    Join Date
    03-12-2010
    Location
    North Lincolnshire, England
    MS-Off Ver
    Excel 2007
    Posts
    36

    Re: multiple column sum product based on set criteria

    Just gone onto my actual spreadsheet and the solution above does not give me what i need basically because there is another variable to take into account. I have attached a mock up sheet of the result i'm after again apologies for messing people about.

    I'm after a solution that gives me total weight by product used by type.

    shift column has 5 options, type column has 9 options, weight is totally variable, product has 15 options and i need to create a series of sheets that give me an answer based on collective data that breaks down what each shift is producing and what by weight they are using to produce each type hopefully the mock up sheet explains it easier.

    I have attached a copy of the actual sheet in order to get a fully working solution please, the data is on the first worksheet and the result sheet (shift scrap usage) is set out in the format i would like to report but have failed to succesfully generate

    again all help gratefully received

    kind regards

    Damion
    Attached Files Attached Files

+ 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