How to create a formula that finds the sum of points for teams

Hello!

Just discovered this forum today, but cannot find the answer. Can any of you help me?

I have uploaded a file. As you will see, it is a simple array of team names with their rankings - 10 points, then 9 points, etc. What I want to calculate in the yellow cell is the total number of points associated with, in that case, the Ducks. The answer should be 49, as the formula would add up everything in cells E2, E3, E4, E5, and G7.

Can it be done? Any suggestions? I've gone around from IF statements, to VLOOKUPS, to them together, to SUMIFs, and on and on. It should be simpler than that!

Thanks in advance!

Melody