Sum totals if date meet

[jeff]

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