chschwei

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.

 

DriverTeanPoints
Driver 1Team 150
Driver 2Team 225
Driver 3Team 120
Driver 4Team 215
TeamPoints
Team 170 (C2+C4)
Team 240 (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

Close

Q: Creating a League Table (racing)

  • All replies
  • Helpful answers

  • by Wayne Contello,

    Wayne Contello Wayne Contello Sep 26, 2016 7:46 AM in response to chschwei
    Level 6 (19,252 points)
    iWork
    Sep 26, 2016 7:46 AM in response to chschwei

    Name the top table in your post "Stats"

     

    Screen Shot 2016-09-26 at 9.44.34 AM.png

     

    make the first row of each table a header row

     

    in the table on the right (named "Summary")

    B2=SUMIF(Stats::B, A2, Stats::C)

     

    this is shorthand for... select cell B2, then type (or copy and paste from here) the formula:

    =SUMIF(Stats::B, A2, Stats::C)

     

    select cell B2, copy

    select cells B2 and B2, paste

     

    you can add as many teams as you want and this formula will continue to function correctly so long as the names are spelled exactly the same in both tables