match two separate arrays with three individual cells

[LuGyver]

This is an odd case I know, but given a ton of data in this sheet, I need to perform the goal without having to rearrange the data or use VB/macro.
The areas of concern are in bold red...
Trying to match E3:F7 with I7:R7 (in this case should = 0,1,3,4), and then see if those matches (0,1,3,4) are equal to either of A8 and/or B8 and/orC8 (in this case B8 = 0 and C8 = 3) and ultimately show the count of the matches in T7 = 2 match in this case.
Note: A8=5 is not found in E3:F7 and therefore does not match with I7:R7, however B8 and C8 does match the criteria.

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T
1	1	2	2		7	7			0	0	1	3	8	7	4	1	1	0
2	6	5	4		8	8			1	0	2	0	9	8	5	2	2	1
3	1	6	6		1	0			0	1	3	1	10	9	6	3	0	2
4	3	7	2		9	8			0	2	4	2	0	10	0	4	1	3
5	1	8	8		1	0			1	3	5	3	1	0	0	0	2	4
6	2	7	8		4	3			2	0	6	4	0	0	1	1	3	5
7	9	8	1		3	1			3	0	7	5	1	1	0	2	4	6		2
8	5	0	3		5	6			4	1	8	6	2	0	1	0	5	0
9	5	2	2		5	8			0	2	9	7	3	0	0	1	6	1

<tbody>
</tbody>

Thank you for your Help

 

[Marcelo Branco]

What would be the expected result if in A8:C8 there were 0 0 3? Would the desired result be 2 or 3?

M.

 

[LuGyver]

What would be the expected result if in A8:C8 there were 0 0 3? Would the desired result be 2 or 3?

M.

result would be 3. thank you for asking edit: 3 would be the max of course

 

[yky]

Basically, you want to know how many in A8:C8 appears in both E3:F7 and I7:R7, right? Try this:

=SUMPRODUCT(--(COUNTIF(E3:F7,A8:C8)*COUNTIF(I7:R7,A8:C8)>0))

 

[LuGyver]

Yes and at the same instance..., and you nailed it perfectly! Thank you so much!