Altering values of one cell in increments based on the value of cells in a row

[Murchie]

I'm a little bit stuck trying to create a formula for a spreadsheet that I am working on.

I am trying to simplify data I have collected in a table into two cells, what I need to do is have the value of the cell I have marked x to increase by +1 (starting from 0) for each green cell with a 1 in it on each row (the x value for each week is based on the number of green cells with a 1 in them on that row)

I also would like for the value of the cell I have marked y to increase by +1 (starting from 0) for each red cell with a 2 in it on each row. The colour of the cells is irrelevant to the formula I would only like for the cell values to be used in the formula.

Any help on this would be greatly appreciated

Here is the worksheet I am working on.

Football Balance Sheet.xlsx
	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z
3	1	02/12/2022			1	1		2	2			1	1	1		1	1							7	2
4	2	09/12/2022		1	1	1		2	2		2	1		1		1		1	1		1			9	3
5	3	16/12/2022			1	1								1								1		x	y
6	4	23/12/2022			1	1								1										x	y
7	5	30/12/2022			1	1								1										x	y
8	6	06/01/2023			1	1								1										x	y
9	7	13/01/2023			1	1								1										x	y
10	8	20/01/2023			1	1								1										x	y
11	9	27/01/2023			1	1								1										x	y
12	10	03/02/2023			1	1								1										x	y
Dec-Feb 2023

 

[Fluff]

How about for Y3

=Countifs(D3:W3,1)

& for Z3 change the 1 to a 2

 

[Murchie]

How about for Y3

=Countifs(D3:W3,1)

& for Z3 change the 1 to a 2

It worked perfectly thank you so much for your help, I'm very much a beginner when it comes to excel so thank you for taking your time to help me

 

[Fluff]

You're welcome & thanks for the feedback.