SUMIFS and text

Hello, I'm wondering if SUMIFS or another function can be used to return text based on multiple variables. I have attached a file with example data to help explain what I am trying to achieve.

In the file there is example data from columns A-F. A pivot table starting in H1. And lastly an area of cells where I am curious to know if there is a formula that can used to achieve the result I am looking for; cells highlighted in red.

The result I am trying to achieve is; retrieve the top 5 spending groups based on a particular week in question. In this example I have chosen week 2, created a pivot table (H1) and used the results here to achieve the results in the area below. I can use SUMIFS to calculate the the numerical values without any problems (cells highlighted in green). However, is there a formula that can achieve the same results for the text? I have discovered the Index formula that can look for text within a set of data but I have had to specify the text I am looking for. In this example the text is likely to change week on week. I know I can achieve the results using pivot tables but am wondering if it can be done using good old formulas.

Hope I have explained my problem well. Please ask for more details if needed. Really appreciate your help, thanks!
example data.xlsx

thanks for your help sandy. i'm not actually sure what this has returned, when inputting your formula i get the result 379.40. i'm not familiar with the large sum, not what i'm after but thanks again.

i'd like a formula (if possible) to replicate what the pivot table is doing by returning the text; somehow to return the text (B:B) that has spent the most (C:C) for a particular week (F:F).

sorry jaredf, I made mistake and sum top five cost*sum top five orders*week. I lost condition B:B

Thanks Siva, this does result with what I am after but still wondering if it can be done without the use of pivot tables?

Thank Sandy, still not sure how to use your method, could you write out your edited formula please using your method described above?

Jared

it was mistake ignore me

Wow Siva you got it! Thank you.

I can understand the SUMIFS within your formula, but not the rest. I'm new to Index and have never used COUNTIF before. Could you kindly explain how you worked that out in layman terms, I'd really appreciate it. Would help me to understand more. If not, not to worry thanks again!

Appreciate your input all