Using sumif and sumproduct together

[aidanhussain]

I have a spreadsheet of values. They have baseball players names and total value (numerical). I was able to use SUMIF to calculate the total for every team's players. How can I use SUMPRODUCT to calculate the total of the top 5 players for every team?

 

[FDibbins]

Use sumifS() with 1 criteria being ">="&large(score-range,5)