Countif with data from 2 tables

[Natit]

Hi,
I'm looking for a function that will give me the results as appear in cells v3:w6.
For example: If Data9 = 3, find to what group it belongs by comparing Workers_num1 to Workers_num2 and get the right group from column O
TIA
Nati

Worker_num1	Data2	Data3	Data4	Data5	Data6	Data7	Data8	Data9			Worker_num2	Head2	Head3	Group
815					8		460	3			815	30002020		1		Group	1	2
843					8		430	3			843	30002020		2		Data9=3	1	4
844					3		130				844	30002020		2		Data6=3	10	5
845					8		430				845	30002020		2		Data6=5	6	3
850					3		130				850	30002020		2		Data6=8	4	6
1588					3		151				1588	30002020		2
1599					3		160				1599	30002020		1
1717					3		160				1717	30002020		1
1729					5		461				1729	30002020		1
1796					8		460				1796	30002020		1
1805					5		460				1805	30002020		1
1856					3		141				1856	30002020		1
1859					3		150				1859	30002020		1
1971					8		461	3			1971	30002020		2
1980					5		450				1980	30002020		1
1982					5		451				1982	30002020		2
2028					3		161				2028	30002020		1
2068					3		161				2068	30002020		1
2091					5		460				2091	30002020		1
2092					3		150				2092	30002020		2
2102					3		150				2102	30002020		2
2104					8		450				2104	30002020		2
2137					5		460				2137	30002020		1
2146					3		150				2146	30002020		1
2166					3		131				2166	30002020		1
2175					3		151				2175	30002020		1
2224					5		450				2224	30002020		1
2225					3		141				2225	30002020		1
2227					8		441				2227	30002020		1
2238					8		460				2238	30002020		1
2240					8		450				2240	30002020		2
2242					5		451	3			2242	30002020		2
2254					8		461	3			2254	30002020		2
2261					5		461				2261	30002020		2

 

[Fluff]

How about

Fluff.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S
1	Worker_num1	Data2	Data3	Data4	Data5	Data6	Data7	Data8	Data9			Worker_num2	Head2	Head3	Group
2	815					8		460	3			815	30002020		1		Group	1	2
3	843					8		430	3			843	30002020		2		Data9=3	1	4
4	844					3		130				844	30002020		2		Data6=3	10	5
5	845					8		430				845	30002020		2		Data6=5	6	3
6	850					3		130				850	30002020		2		Data6=8	4	6
7	1588					3		151				1588	30002020		2
8	1599					3		160				1599	30002020		1
9	1717					3		160				1717	30002020		1
10	1729					5		461				1729	30002020		1
11	1796					8		460				1796	30002020		1
12	1805					5		460				1805	30002020		1
13	1856					3		141				1856	30002020		1
14	1859					3		150				1859	30002020		1
15	1971					8		461	3			1971	30002020		2
16	1980					5		450				1980	30002020		1
17	1982					5		451				1982	30002020		2
18	2028					3		161				2028	30002020		1
19	2068					3		161				2068	30002020		1
20	2091					5		460				2091	30002020		1
21	2092					3		150				2092	30002020		2
22	2102					3		150				2102	30002020		2
23	2104					8		450				2104	30002020		2
24	2137					5		460				2137	30002020		1
25	2146					3		150				2146	30002020		1
26	2166					3		131				2166	30002020		1
27	2175					3		151				2175	30002020		1
28	2224					5		450				2224	30002020		1
29	2225					3		141				2225	30002020		1
30	2227					8		441				2227	30002020		1
31	2238					8		460				2238	30002020		1
32	2240					8		450				2240	30002020		2
33	2242					5		451	3			2242	30002020		2
34	2254					8		461	3			2254	30002020		2
35	2261					5		461				2261	30002020		2
36
Sheet6

Cell Formulas
Range	Formula
R3:S3	R3	=SUM(COUNTIFS($O:$O,R2,$L:$L,FILTER($A$2:$A$100,$I$2:$I$100=3)))
R4:S4	R4	=SUM(COUNTIFS($O:$O,R2,$L:$L,FILTER($A$2:$A$100,$F$2:$F$100=3)))
R5:S5	R5	=SUM(COUNTIFS($O:$O,R2,$L:$L,FILTER($A$2:$A$100,$F$2:$F$100=5)))
R6:S6	R6	=SUM(COUNTIFS($O:$O,R2,$L:$L,FILTER($A$2:$A$100,$F$2:$F$100=8)))

 

[Natit]

This forum never failed me.
After adaptions, works perfect.
Thanks

 

[Fluff]

You're welcome & thanks for the feedback.