Very Difficult Question

Izo12

New Member
Joined
Mar 8, 2011
Messages
5
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.
 
Last edited:

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

jmthompson

Well-known Member
Joined
Mar 31, 2008
Messages
966
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
Joined
Mar 8, 2011
Messages
5
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
Joined
Mar 31, 2008
Messages
966
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
Joined
Mar 8, 2011
Messages
5

ADVERTISEMENT

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

Forum statistics

Threads
1,144,388
Messages
5,724,071
Members
422,533
Latest member
garganod1

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top