Sum totals if date meet

**jeff** · 01-19-2014, 08:13 AM

I need to add a further group..when the transfer for MS PLANNED,MS INTERNAL & MS EXTERNAL transfer can there also be another group transferred at the same time.....same criteria as MS ,look at the date ,Place the word "JUICE" in 'GROUP A'!O45,find all words with the name Juice in column K (JUICE-ORANGE and JUICE-PEAR) and sum up VOLUME and transfer to Sheet!Group A P45,same for Time in Column N and transfer to Q45...Place the word "WATER" in 'GROUP A'!O46,find all words with the name WATER in column K (WATER-CLEAR and WATER-COLORED) and sum up Volume and transfer to Sheet!Group A P46,same for Time in Column N and transfer to Q46...Place the word "ALC" in 'GROUP A'!O47,find all words with the name ALC in column K (ALC-RED and ALC-WHITE) and sum up Volume and transfer to Sheet!Group A P47,same for Time in Column N and transfer to Q47...
Sample Files shows the outcome..done manually to show
Thanks

**jeff** · 01-30-2014, 07:07 PM

Still hoping for some help please
Thanks
Jeff

**jeff** · 02-02-2014, 07:25 PM

**Excel Fox** · 02-03-2014, 06:46 PM

Also, I think Team A subtotal for Water should be 54000, but it shows as 42000 in your manual output. can you explain how

**Excel Fox** · 02-03-2014, 06:41 PM

In the sample you have uploaded, you only have 3 groups. And the manual output you've created also only contains 3 groups. Can you upload a file with the 4 groups, so that your requirement is clearly understood.

**jeff** · 02-03-2014, 08:35 PM

Thanks
Yes you are correct it should be 54000
There is only the 3 groups as i removed Quality
When the userform is used to transfer the data for the selected Date and Team for Stoppage into it ranges can it also transfers the Product results/info into O45:Q47 (exactly as it looks in sample sheet)
When Clear Data button selected it removes all the data from the ranges except Headings
Sample attached

Thanking you