Not sure if VBA is needed or a formula. I have a spreadsheet with 10,000 rows of data. The 5 columns are Dates, Site, Brand, Style, and Quantity. I have a simple SUMIFS function that will sum the quantity based on What date range, site, brand, and style the user chooses. That was easy enough...The tough part is actually summing up the individual styles and displaying those in a list.

For Example:

Date Site Brand Style Quantity
9/1/13 A.com XYZ 1A 10
9/1/13 A.com XYZ 1A 20
9/1/13 A.com XYZ 1B 5
9/1/13 A.com XYZ 1A 10
9/1/13 A.com XYZ 1B 50
9/1/13 A.com XYZ 1C 5

The above mentioned formula would simply Sum all this up and display:
Site Brand Quantity
A.com XYZ 100

What I am needing help with is being able to display this also:
Site Brand Style Quantity
A.com XYZ 1A 40
A.com XYZ 1B 55
A.com XYZ 1C 5

Keep in mind this could potentially be up to 100 styles, and the number is not static and is always changing as more data gets added. Some brands could have 1 style, and some could have 100, or more. However, the Brand and Site would always be the same.