Sumifs, large & rank

Hi,

I can do this manually through filters but I'd like to learn how to do it automatically through a formula.

I have a dataset where I have countries in column A, customers in column B, type of sale in column C and units in column D and there are several invoices for each customer. I would like to find the highest ranking customer (i.e. with the highest amount of total sales) for each type of sale and in each country e.g. find the name and total number of sales for type "Goods" in country "Germany".

I created a table and used SUMIFS to find out the totals and then used =INDEX($C:$C,MATCH(LARGE(D:D,1),D:D,0)) on my table to find out the highest for each type of sale however, I'm unable to figure out how to add another criteria.

Any help would be much appreciated.

Thanks,
M

Originally Posted by OllyXLS

Why not use a pivot table?

It's a very large dataset