Hello Hello.

I have been working on this for 2 days and it's now time for more brains:

I have an excel sheet of 8000 products (rows) from a supermarket. Column A are product names (The Economist, New York Times, Snickers, Time Magazine, etc) Column B has each product broken down by % of category sales (the economist is 3.9% of magazine sales, People is 2.9% of magazine sales, etc) and Column C is the category (Newspapers, magazines, candy, beverage, etc). I'm attempting to make a separate chart that sums the percent of sales of:

the top 5 highest grossing magazines (I want to know the top 5 magazines represent __% of my total magazine sales)
the top 10 highest grossing magazines
the top 15 highest grossing magazines
all the way up to the top 50 magazines

I'll be doing this for about 20 different categories, and I'm hoping some simple formulas would do the trick. My problem is (well, at least one of my problems!) that I don't know how to combine a sumif (or sumifs) function while also plugging in the criteria of adding up just the top 5 (or top 50) highest values (percentages) of ONLY magazines (and then ONLY Newspapers, etc). Or, perhaps I shouldn't be trying to combine these formulas. Also, this worksheet will constantly be sorted in different ways, so the formulas have to be able to handle unsorted columns. Any ideas????

Many thanks!

~ Scooby