Formula for Basketball Minutes per Game

[fireburtbusto]

I know once I see how to do this I am going to kick myself as to how simple it is, but can not figure it out.
I am wanting to calculate how many minutes per game each player play in a basketball game.

I want the Min/Gm column to sum how many minutes during the game each player played. The Clock column shows each time the game clock stops and a substitution is made.

A	B	C	D	E	F	G	H	I	J
Clock	Min Interval	Player	Player	Player	Player	Player	.....	Player	Min/Gm
18:00	5:00	5	15	24	45	55		3	8:30
13:00	4:30	5	15	31	45	55		5	9:30
8:30	6:30	3	15	31	45	55		15
2:00	2:00	3	15	24	42	55		24
0:00

<tbody>
</tbody>

I was thinking a SUMIF formula, but can't get it to work. Any help would be great.

 

[shg]

	A​	B​	C​	D​	E​	F​	G​	H​	I​	J​	K​
1​	Clock​	Min Interval​	Player​	Player​	Player​	Player​	Player​	.....​	Player​	Min/Gm​	​
2​	18:00​	5:00​	5​	15​	24​	45​	55​		3​	8:30​	J2: =SUMPRODUCT(($C$2:$G$5=I2) * $B$2:$B$5)
3​	13:00​	4:30​	5​	15​	31​	45​	55​		5​	9:30​
4​	8:30​	6:30​	3​	15​	31​	45​	55​		15​	18:00​
5​	2:00​	2:00​	3​	15​	24​	42​	55​		24​	7:00​
6​	0:00​

 

[fireburtbusto]

Oh my. Like I said, kicking myself. Thank you so much.

 

[shg]

You're welcome.