Need formula to calculate running score total for different teams across different games??

[ea2146]

Hello,

I would greatly appreciate any help with this problem. I have basketball data in which I have the outcome of each play, but not a running score total for each team. I need a formula to calculate the running score total for each team. The tricky part is that there are a number of different games (each with different teams playing each other) in my dataset.

I have attached a sample spreadsheet with some of the data I have. I need help creating a formula to calculate the values in the columns "RUNNING SCORE TEAM 1" and "RUNNING SCORE TEAM 2". Thank you so much in advance for any help that you can offer!! [TABLE="width: 685"]
<tbody>[TR]
[TD]Game ID[/TD]
[TD]team[/TD]
[TD]points[/TD]
[TD]result[/TD]
[TD]RUNNING SCORE TEAM 1[/TD]
[TD]RUNNING SCORE TEAM 2[/TD]
[/TR]
[TR]
[TD]GAME1[/TD]
[TD]SAS[/TD]
[TD][/TD]
[TD]missed[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]GAME1[/TD]
[TD]DAL[/TD]
[TD][/TD]
[TD]missed[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]GAME1[/TD]
[TD]SAS[/TD]
[TD][/TD]
[TD]missed[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]GAME1[/TD]
[TD]SAS[/TD]
[TD]1[/TD]
[TD]made[/TD]
[TD]1[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]GAME1[/TD]
[TD]DAL[/TD]
[TD][/TD]
[TD]missed[/TD]
[TD]1[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]GAME1[/TD]
[TD]SAS[/TD]
[TD]2[/TD]
[TD]made[/TD]
[TD]3[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]GAME1[/TD]
[TD]DAL[/TD]
[TD]3[/TD]
[TD]made[/TD]
[TD]3[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]GAME1[/TD]
[TD]SAS[/TD]
[TD][/TD]
[TD]missed[/TD]
[TD]3[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]GAME1[/TD]
[TD]DAL[/TD]
[TD][/TD]
[TD]missed[/TD]
[TD]3[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]GAME1[/TD]
[TD]SAS[/TD]
[TD][/TD]
[TD]missed[/TD]
[TD]3[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]GAME1[/TD]
[TD]SAS[/TD]
[TD]2[/TD]
[TD]made[/TD]
[TD]5[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]GAME1[/TD]
[TD]DAL[/TD]
[TD][/TD]
[TD]missed[/TD]
[TD]5[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]GAME1[/TD]
[TD]DAL[/TD]
[TD][/TD]
[TD]missed[/TD]
[TD]5[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]GAME1[/TD]
[TD]SAS[/TD]
[TD][/TD]
[TD]missed[/TD]
[TD]5[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]GAME1[/TD]
[TD]DAL[/TD]
[TD][/TD]
[TD]missed[/TD]
[TD]5[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]GAME1[/TD]
[TD]SAS[/TD]
[TD]2[/TD]
[TD]made[/TD]
[TD]7[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]GAME1[/TD]
[TD]DAL[/TD]
[TD]2[/TD]
[TD]made[/TD]
[TD]7[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]GAME1[/TD]
[TD]SAS[/TD]
[TD][/TD]
[TD]missed[/TD]
[TD]7[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]GAME1[/TD]
[TD]SAS[/TD]
[TD][/TD]
[TD]missed[/TD]
[TD]7[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]GAME1[/TD]
[TD]SAS[/TD]
[TD][/TD]
[TD]missed[/TD]
[TD]7[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]GAME1[/TD]
[TD]DAL[/TD]
[TD][/TD]
[TD]missed[/TD]
[TD]7[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]GAME1[/TD]
[TD]SAS[/TD]
[TD]2[/TD]
[TD]made[/TD]
[TD]9[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]GAME1[/TD]
[TD]DAL[/TD]
[TD]2[/TD]
[TD]made[/TD]
[TD]9[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]GAME1[/TD]
[TD]SAS[/TD]
[TD][/TD]
[TD]missed[/TD]
[TD]9[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]GAME1[/TD]
[TD]SAS[/TD]
[TD]2[/TD]
[TD]made[/TD]
[TD]11[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]GAME1[/TD]
[TD]SAS[/TD]
[TD]1[/TD]
[TD]made[/TD]
[TD]12[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]GAME1[/TD]
[TD]DAL[/TD]
[TD][/TD]
[TD]missed[/TD]
[TD]12[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]GAME1[/TD]
[TD]DAL[/TD]
[TD]2[/TD]
[TD]made[/TD]
[TD]12[/TD]
[TD]9[/TD]
[/TR]
[TR]
[TD]GAME1[/TD]
[TD]DAL[/TD]
[TD][/TD]
[TD]missed[/TD]
[TD]12[/TD]
[TD]9[/TD]
[/TR]
[TR]
[TD]GAME2[/TD]
[TD]UTA[/TD]
[TD]2[/TD]
[TD]made[/TD]
[TD]2[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]GAME2[/TD]
[TD]PHX[/TD]
[TD]2[/TD]
[TD]made[/TD]
[TD]2[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]GAME2[/TD]
[TD]PHX[/TD]
[TD]2[/TD]
[TD]made[/TD]
[TD]2[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]GAME2[/TD]
[TD]UTA[/TD]
[TD]2[/TD]
[TD]made[/TD]
[TD]4[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]GAME2[/TD]
[TD]PHX[/TD]
[TD][/TD]
[TD]missed[/TD]
[TD]4[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]GAME2[/TD]
[TD]UTA[/TD]
[TD]2[/TD]
[TD]made[/TD]
[TD]6[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]GAME2[/TD]
[TD]PHX[/TD]
[TD][/TD]
[TD]missed[/TD]
[TD]6[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]GAME2[/TD]
[TD]UTA[/TD]
[TD]3[/TD]
[TD]made[/TD]
[TD]9[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]GAME2[/TD]
[TD]PHX[/TD]
[TD]2[/TD]
[TD]made[/TD]
[TD]9[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]GAME2[/TD]
[TD]UTA[/TD]
[TD]3[/TD]
[TD]made[/TD]
[TD]12[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]GAME2[/TD]
[TD]PHX[/TD]
[TD]1[/TD]
[TD]made[/TD]
[TD]12[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]GAME2[/TD]
[TD]PHX[/TD]
[TD]1[/TD]
[TD]made[/TD]
[TD]12[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]GAME2[/TD]
[TD]UTA[/TD]
[TD][/TD]
[TD]missed[/TD]
[TD]12[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]GAME2[/TD]
[TD]UTA[/TD]
[TD][/TD]
[TD]missed[/TD]
[TD]12[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]GAME2[/TD]
[TD]PHX[/TD]
[TD][/TD]
[TD]missed[/TD]
[TD]12[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]GAME2[/TD]
[TD]PHX[/TD]
[TD]2[/TD]
[TD]made[/TD]
[TD]12[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]GAME2[/TD]
[TD]UTA[/TD]
[TD]2[/TD]
[TD]made[/TD]
[TD]14[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]GAME2[/TD]
[TD]PHX[/TD]
[TD][/TD]
[TD]missed[/TD]
[TD]14[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]GAME2[/TD]
[TD]PHX[/TD]
[TD]1[/TD]
[TD]made[/TD]
[TD]14[/TD]
[TD]11[/TD]
[/TR]
[TR]
[TD]GAME2[/TD]
[TD]UTA[/TD]
[TD][/TD]
[TD]missed[/TD]
[TD]14[/TD]
[TD]11[/TD]
[/TR]
[TR]
[TD]GAME2[/TD]
[TD]PHX[/TD]
[TD][/TD]
[TD]missed[/TD]
[TD]14[/TD]
[TD]11[/TD]
[/TR]
[TR]
[TD]GAME2[/TD]
[TD]UTA[/TD]
[TD]2[/TD]
[TD]made[/TD]
[TD]16[/TD]
[TD]11[/TD]
[/TR]
[TR]
[TD]GAME2[/TD]
[TD]PHX[/TD]
[TD]3[/TD]
[TD]made[/TD]
[TD]16[/TD]
[TD]14[/TD]
[/TR]
[TR]
[TD]GAME2[/TD]
[TD]UTA[/TD]
[TD][/TD]
[TD]missed[/TD]
[TD]16[/TD]
[TD]14[/TD]
[/TR]
[TR]
[TD]GAME2[/TD]
[TD]UTA[/TD]
[TD][/TD]
[TD]missed[/TD]
[TD]16[/TD]
[TD]14[/TD]
[/TR]
[TR]
[TD]GAME2[/TD]
[TD]UTA[/TD]
[TD]2[/TD]
[TD]made[/TD]
[TD]18[/TD]
[TD]14[/TD]
[/TR]
[TR]
[TD]GAME2[/TD]
[TD]PHX[/TD]
[TD]2[/TD]
[TD]made[/TD]
[TD]18[/TD]
[TD]16[/TD]
[/TR]
[TR]
[TD]GAME2[/TD]
[TD]UTA[/TD]
[TD][/TD]
[TD]missed[/TD]
[TD]18[/TD]
[TD]16[/TD]
[/TR]
[TR]
[TD]GAME2[/TD]
[TD]PHX[/TD]
[TD][/TD]
[TD]missed[/TD]
[TD]18[/TD]
[TD]16[/TD]
[/TR]
[TR]
[TD]GAME2[/TD]
[TD]UTA[/TD]
[TD]2[/TD]
[TD]made[/TD]
[TD]20[/TD]
[TD]16[/TD]
[/TR]
</tbody><colgroup><col><col><col span="2"><col><col></colgroup>[/TABLE]

 

[just_scott]

hi ya

Presuming that cell e1 is "RUNNING SCORE TEAM 1"
Put this into e2

=SUMIF($B$2:$B2,B2,$C$2:$C2)

if you want it to restart the count for each new game you'll need something like:

=if(a2=a1,c2,
=SUMIF($B$2:$B2,B2,$C$2:$C2)

 

[ea2146]

Thanks for this...it doesn't quite do the trick, but gets me very close.