pass array into dictionary to sum product by description and type

[nigelog]

Hi All

Output from a database records in strings product items. The following code divides those string into block of three into a public array called temp

Please Login or Register  to view this content.

And dictionary

Please Login or Register  to view this content.

I have used dictionary's but cannot find my source workbooks so would appreciate a few pointers as to how to count the various types

I want to pass the array elements into the dictionary to give me totals of each product featured and the package type. A bonus would be any array entry containing the word "DEAL" would be omitted from the dictionary.

Work attached shows string types from database - array formed - and desired output totals
Many thanks

[dangelor]

Possibly...

Please Login or Register  to view this content.

[Artik]

It turned out a bit different for me.
Code can be reduced by not using the Type Product, but in such a form is more understandable.

Please Login or Register  to view this content.

Artik

[nigelog]

Thankyou both for your efforts.. I have some studying to do
Many thanks
After checking Artik's code does all in a single pass, I will mark as solved...thanks again to you both