I have a Racing leaderboard that i need help with. I have it all layed out but im having trouble with keeping certain thing locked to each other. Also i would like to have it auto sort when times are updated as opposed to having to select the ranges and doing a filter manually.
Frenzy Red.xlsx

I have it already doing a rank of each time per section but i would like the points for position to be tallied on far left section in accordance to the rider across all four races.
Thanks for any help that is provided.