I have a large list of data that is grouped. I want to find the Top 5 within each group, but then SUM a different cell in the rows of the Top 5.

I have attached a file that helps explain the situation in more detail (real data).

Column A: Grouping
Column B: #s to obtain the Top 5 from (using LARGE function, I assume)
Column C: #s I want to sum from the Top 5 (as determined by Column B

I spent the majority of yesterday working on this and cannot figure it out.

Any help greatly appreciated!Test.xlsx