# Very Difficult Question

#### Izo12

##### New Member
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
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:

### Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

#### jmthompson

##### Well-known Member
Where will you house the school totals, different tab?

and is a gross total ok or do you need the school totals by category?

Have you tried a pivot table?

#### Izo12

##### New Member
I'd like to have a separate column on the same spreadsheet that shows the total amount of points scored by each team. I'm not the greatest at the pivot tables. Is that the only way to do something like this? Gross total is what I'm looking for.

#### jmthompson

##### Well-known Member
Pivots are not the only way, just the most flexible
The simplest formula is this
Code:
``=SUMIF(C:C,"=A",E:E)``

The =A would be changed to =SchoolName. This assumes that your school names are in col;umn c and your points are in column e

#### Izo12

##### New Member

I'll try it out now. Thanks a million.

#### Izo12

##### New Member
Works like a charm man. Thanks.

#### jmthompson

##### Well-known Member
Wo-man. You're welcome!

#### Izo12

##### New Member
Thousand pardons.

Replies
2
Views
222
Replies
8
Views
169
Replies
1
Views
181
Replies
3
Views
95
Replies
3
Views
203

1,141,734
Messages
5,708,168
Members
421,549
Latest member
Dtcfire

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back