Q: Creating a League Table (racing)
Hello everyone,
I'm relatively new to Numbers and I'm currently trying to create a league table for a racing game (F1 2016). A friend and I play in an online season and we wanted to document our results and championship standings.
I have one problem I can't seem to solve on my own, though. Also couldn't really find anything on Google.
On the first page I created an overview of the total points for drivers and teams. I used =RANK to rank the drivers and teams based on their total points which works fine.
I want Numbers to automatically calculate the teams' total points by adding the corresponding drivers' points. So right now it looks something like this.
| Driver | Tean | Points |
|---|---|---|
| Driver 1 | Team 1 | 50 |
| Driver 2 | Team 2 | 25 |
| Driver 3 | Team 1 | 20 |
| Driver 4 | Team 2 | 15 |
| Team | Points |
|---|---|
| Team 1 | 70 (C2+C4) |
| Team 2 | 40 (C3+C5) |
However, if let's say Driver 3 moves up one spot after the next race, =SUM still takes the same cell as before (C4) which now contains a driver of another team,
So my question is, how can I tell Numbers to always add the points of the drivers who belong to the same team so that the formula automatically adjusts to changes in the driver rankings?
Thanks in advance, I kind of feel like this isn't that hard but I really have no idea what to do.
Posted on Sep 26, 2016 5:58 AM
