Calculate spare matches

[RichTheBowler]

	1		2		3		4		5		6		7		8		9		10
X		9	\	X		X		X		9	\	8	\	9	\	X		9	\	X
20	40	70	99	119	137	156	176	196	216
	"10"				"10"	"6 10"	"4"		"10"

<tbody>
</tbody>

Line 1: Is lane numbers
Line 2: Is what was bowled in each frame
Line 3: Is the score attained in each frame
Line 4: Is the spare combination left after throwing the first ball

In this example: I left the "10" pin in frames 2,5, 10 and made all three spares.

Need formula to look at the value in line 4. Example: "10" and match with all spare values "the backslash" to count spares made by value "10" and subsequent values:
"6 10", "4", etc.

I tried =countifs, but does not work because the ranges in line 2 and 4 do not match, they are different sizes.

Thanks,
RichTheBowler

<tbody>
</tbody>

 

[AlanY]

someone has produced a template, check it out

https://exceltemplate.net/tournament/bowling/