How to keep a score?

Your sentence is a little confusing but paired with your example I think you mean this:

Each column is a player. For each player, sum the values in that column that correspond to a header in column A ("game") that includes a "2".

This requires an array formula in row 2. (For your Excel version it would help to give the commercial version [e.g., Excel 2019, Office 365] rather than the release identifier. It makes it easier to determine what functionality is available in your version.)

Values as displayed

	A	B	C
1		score 1	score 2
2		1	0
3	game	player 1	player 2
4	a 2	1
5	b		1
6	c	1	1
7	d2

Underlying formulas

	A	B	C
1		score 1	score 2
2		=SUM(IF(ISNUMBER(FIND("2",Table2[game])),Table2[player 1],0))	=SUM(IF(ISNUMBER(FIND("2",Table2[game])),Table2[player 2],0))
3	game	player 1	player 2
4	a 2	1
5	b		1
6	c	1	1
7	d2

This is an array formula. After typing in the formula, do not hit ENTER--hit CTRL+SHIFT+ENTER. You have done it correctly if the formula in the formula box has {braces} around it. You cannot type in the braces; they are just an indicator that it is an array formula.

Thanks. Is there a way to paste it under new players with the absolute(game) and relative(player #) columns pasted in correctly? I'm using android version of excel.

Also, can I substitute SUM with COUNTIF if I don't actually want the sum of the numbers in the cells but just a count of the cells with data in them? Thanks

I don't know anything about what is supported on Android. I have updated the formula for counts, and here is the whole file to try on Android. You will have to update the formula for each additional column because it uses structured references. But the advantage is that it doesn't matter how many rows are in your table.

Thanks!....

Could I bother to help out with another modification? I want the score to count now as long as the corresponding cell in this new "odds" column value is positive. This is related to betting if this helps any to see what I'm doing here but not necessary. Hope it doesn't require a whole different set of functions. I was trying to do this step by step as simply as possible but it's not that simple I guess or I'm making it complicated. What do ya think? Looks like a "countif/sum(if" corresponding cell in x column >0 and idk how you'd do that exactly. Thanks!

Oh never mind, I found this elsewhere:

=SUMPRODUCT((ISNUMBER(SEARCH("1",$A4:$A12)))*($B4:$B12>0)*(C4:C12>0))

Which also allows me to keep those two columns absolute.