Multiple criteria subtotals to find top 10

[nmadd]

Hi all,

I have a large set of data that looks very roughly like this with many different values in each column.

Please Login or Register  to view this content.

What I would like to do is find the top 10 items in order of sales for a specified type/category/quarter/year combination. So for Adventure Books for Q2 2010, which items had the most sales; subtotal those sales and present the top 10 items with sales on a separate worksheet, ala

Please Login or Register  to view this content.

Can somebody point me in the proper direction by mentioning some formulas, VBA, logic that you would start with? Let's say no PivotTable suggestions please and I'd prefer if you just didn't post what you thought was the right formula/VBA - I'd like to learn with a little push from you.

[NBVC]

How about I post a sample workbook (formula based solution), you can see what is going on... and learn from that and ask questions as required....

If you don't want to open the workbook, and see if someone will "push" you... then that's okay too...