Individual and team (sport) rankings:
• 14 individual rankings and 1 team ranking (15 total worksheets)
• Need excel formula for team rankings. All the individual rankings for a team to make the sum of their tournament points.
• Here is my tournament team ranking formula: If ranked 1=24 team points, if ranked 2=20 team points, if ranked 3=16 team points, if ranked 4=14 team points, if ranked 5=11 team points, if ranked 6=9 team points, if ranked 7=7 team points, if ranked 8=6 team points, if ranked 9 thru 12= 4 team points.
• Ex. "School A" has 3 individuals ranked 1, 2 & 5. "School A" tournament points are 24 (rank 1) + 20 (rank 2) + 11 (rank 5)= 55

This sounds harder than it really is. Maybe a visual would work better?

Thank you! -Tito