# multiple column sum product based on set criteria

1. ## 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

2. ## Re: multiple column sum product based on set criteria

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

Drag Across to Q4, then Down as required.

3. ## 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. ## 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. ## 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

##### Users Browsing this Thread

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

#### 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