Count Diagonals

[motilulla]

Hi everyone,</SPAN></SPAN>

The below example I have all 1 I want to count 2 Diagonal and 3 Diagonal as shown</SPAN></SPAN>

Where I need to count diagonal right side of the upper rows and left side of the lower rows</SPAN></SPAN>

For example1: if we check in row 5 we have 3 diagonal with 2 match</SPAN> (first in cell E5=1 and cell F4=1) second in cell J5=1 and cell K4=1, and last (third in cell L5=1 and M4=1) </SPAN></SPAN>

For example1: if we check in row 6 we have </SPAN>3 diagonal with 2 match and 1 with 3 match</SPAN> (first in cell E7=1 and cell E6=1) second in cell F7=1 And cell G6=1, and 3 diagonal match are In cell F7=1, cell G6=1 and Cell E8=1</SPAN></SPAN>

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1	Game	1	2	3	4	5	6	7	8	9	10	11	12	13	14	Total match 2 diagonal	Total match 3 diagonal
2	1		1
3	2			1						1					1
4	3					1		1			1		1
5	4	1			1				1	1		1		1		3
6	5				1		1								1
7	6	1		1		1										2	1
8	7				1							1			1	1
9	8	1				1	1	1		1	1					1
10	9				1				1							2
11	10
12	11	1	1		1	1		1	1		1
13	12											1		1
14	13				1		1				1		1			2
15	14		1

<COLGROUP><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL></COLGROUP><THEAD>
</THEAD><TBODY>
</TBODY>

Mr.Excel​

Results are shown in columns P And Q</SPAN></SPAN>

Please help</SPAN></SPAN>

Thanks And Regards,</SPAN></SPAN>
Moti</SPAN></SPAN>

 

[Jerry Sullivan]

You're most welcome, Moti.

Thank you for your kind feedback.

 

[starl]

test

 

[ZAX]

test

I can notice the color of the word Administrator and Excel MVP has changed.
ZAX

 

[starl]

from what? Mod titles are colored...