Count of total requests assigned

[Jonam711]

Sorry guys for the blurred image. I need count the total assignings for employees based on the first table. There are two different categories (requests and tickets) and the total of both has to be derived in the total assigned column in second table. Thanks guys!

 

[Jonam711]

It'd be simpler if each row had a name, but it'd be similar to the merged cells.

Book2
	A	B	C	D	E	F	G
1						Drag down	Spill formula
2	Jack	A			Jack	6	6
3		B			Nick	3	3
4		C			Rick	1	1
5			D
6			E
7			F
8	Nick		G
9			H
10		I
11
12
13
14	Rick
15		J
16
17
18
19
Sheet3

Cell Formulas
Range	Formula
G2:G4	G2	=MAP(E2:E4,LAMBDA(m,SUM(--(FILTER(B2:C19,SCAN("",A2:A19,LAMBDA(a,b,IF(b="",a,b)))=m)<>""))))
F2:F4	F2	=SUM(--(FILTER($B$2:$C$19,SCAN("",$A$2:$A$19,LAMBDA(a,b,IF(b="",a,b)))=E2)<>""))
Dynamic array formulas.

Book2
	A	B	C	D	E	F	G
1						Drag down	Spill formula
2	Jack	A			Jack	6	6
3	Jack	B			Nick	3	3
4	Jack	C			Rick	1	1
5	Jack		D
6	Jack		E
7	Jack		F
8	Nick		G
9	Nick		H
10	Nick	I
11	Nick
12	Nick
13	Nick
14	Rick
15	Rick	J
16	Rick
17	Rick
18	Rick
19	Rick
Sheet3

Cell Formulas
Range	Formula
G2:G4	G2	=MAP(E2:E4,LAMBDA(m,SUM(--(FILTER(B2:C19,A2:A19=m)<>""))))
F2:F4	F2	=SUM(--(FILTER($B$2:$C$19,$A$2:$A$19=E2)<>""))
Dynamic array formulas.

Thanks it worked!

 

[Cubist]

You're welcome.

 

[smozgur]

Thanks it worked!

The marked solution has been changed accordingly. In your future questions, please mark the post as the solution that actually answered your question, instead of your feedback message as it will help future readers. No further action is required for this thread.