I am creating a spreadsheet for my high school's track team and I am running into a problem and it's kind of hard to explain so stay with me. They want me to devise something to where the team totals are updated when each event is finished and they enter the individual winners from various schools.
Now, my category names from left to right are as follows (I'll give an example of what the spreadsheet looks like, don't worry about the white letters in between the columns, i did that to show more of what my spreadsheet looks like):
Eventdddddd Place ddddddSchool ddddddContestant ddddddPoints
Hurdles dddddd1ddddddddddddd Addddddddddddd Joe dddddddddddd10
ddddddddddddd2ddddddddddddd B dddddddddddddJim ddddddddddddd8
ddddddddddddd3 dddddddddddddC ddddddddddddJohnddddddddddddd 6
ddddddddddddd4ddddddddddddd B ddddddddddddJames dddddddddddd4
If the participant finishes in first place, he/she receives 10 points. Second place receives 8 and so on and so forth. Here's the question. You see where school and contestant is side by side? Is there a way that when I put the name of the school of the contestant in, that I can have a calculation that will add up the points respectively. In otherwords, everytime that the School Column says B, it will add up the points in the Points Column. B would have a total of 12 points, A would have 10, and C would have 6.
I know it's hard to understand, but any help will do.
Now, my category names from left to right are as follows (I'll give an example of what the spreadsheet looks like, don't worry about the white letters in between the columns, i did that to show more of what my spreadsheet looks like):
Eventdddddd Place ddddddSchool ddddddContestant ddddddPoints
Hurdles dddddd1ddddddddddddd Addddddddddddd Joe dddddddddddd10
ddddddddddddd2ddddddddddddd B dddddddddddddJim ddddddddddddd8
ddddddddddddd3 dddddddddddddC ddddddddddddJohnddddddddddddd 6
ddddddddddddd4ddddddddddddd B ddddddddddddJames dddddddddddd4
If the participant finishes in first place, he/she receives 10 points. Second place receives 8 and so on and so forth. Here's the question. You see where school and contestant is side by side? Is there a way that when I put the name of the school of the contestant in, that I can have a calculation that will add up the points respectively. In otherwords, everytime that the School Column says B, it will add up the points in the Points Column. B would have a total of 12 points, A would have 10, and C would have 6.
I know it's hard to understand, but any help will do.
Last edited: