Sumproduct for ranking with multiple criterias; maybe sumifs?

Dear experts,

I have a huge favour to ask, which is about automation of a task which involves filtering multiple criterias, sorting then copy and paste to another template. I don't want to free-ride on your expertise, but I tried my best (although inadequate), and your assistance is greatly appreciated.

For easier understanding, please refer to a sample workbook attached. On the first tab, you will see what the data looks like. On the second, it is the instruction and the result that I have pasted idiotically after manual sorting.

Task: to rank revenue from largest to smallest; then filter out multiple criteria from other columns, then copy and paste (perhaps index?)

My plan: To use sumproduct and rank the country revenues, then use vlookup (perhaps combining with concatenate function too) to identify the top rankings for each country.

Problem: I am not just ranking the revenue numbers for each country, but I had to filter out multiple other criterias too (for example, deal status, or certain product type). Is there a formula for this?? How should I approach it without doing VBAs?

Thanks in advance.

sincerely,

deeply troubled individual

maybe, add a column on the data page - for example K in K1 you can input country you would like to filter by - For example China
Then you can add formula K2:K... =if($K$1=$K2,1,"")
Then you can rank in L2:L... if($K2=1,Rank(...... I haven't thought through the formula et
On your table page for 1,2,3 Index(Sheet1!A:L,Match(1(Rank),Sheet1!L:L,0),1) etc...