Sum top 2 scores from across multiple sheets

[SirScott13]

I have a spreadsheet with 6 tabs. Each tab contains the results from a climbing competition. The columns on the tabs are Rank (1-40), Name, & Points (variable). The goal of the spreadsheet is to compile a list of all climbers along with a total of their top 2 highest point totals.

I made an attempt at compiling all of the results into a single tab, but I am having trouble getting the Top 2 distinct results per climber.

Is there a formula that will make this easy? I have looked at the LARGE function, but I don't know how to tie this to the name in the other column.

Any assistance/guidance would be appreciated. You guys helped me a ton on a work project years ago.

 

[SirScott13]

Awesome.

 

[Fluff]

Thanks