Lookup based on Person in top row

[monkeyharris]

Hi, I have a table that works OK but i want to add another criteria to count the number of events per person. It's the last table in the below mini sheet.
I want B29 to lookup a sheet called YTD_Figures and return the number of Sales-i or Sales Quotes against the persons name (top row of that table). In this case the first person is Alina, the Harriet etc.

Woodford Proactive Call Stats.xls
	A	B	C	D	E	F	G	H	I	J	K	L	M
2	Employee	Q1 Contacted	Q1 Not Contacted	Q1 Performance	Q2 Contacted	Q2 Not Contacted	Q2 Performance	Q3 Contacted	Q3 Not Contacted	Q3 Performance	Q4 Contacted	Q4 Not Contacted	Q4 Performance
3	Alina	73	96	43.20%	0	169	0.00%	0	169	0.00%	0	169	0.00%
4	Harriet	70	41	63.06%	0	111	0.00%	0	111	0.00%	0	111	0.00%
5	Jemma	48	63	43.24%	0	111	0.00%	0	111	0.00%	0	111	0.00%
6	Jo	28	82	25.45%	0	110	0.00%	0	110	0.00%	0	110	0.00%
7	Mita	15	31	32.61%	0	46	0.00%	0	46	0.00%	0	46	0.00%
8	Paul	57	53	51.82%	0	110	0.00%	0	110	0.00%	0	110	0.00%
9	Tendayi	48	63	43.24%	0	111	0.00%	0	111	0.00%	0	111	0.00%
10	Zoe	42	68	38.18%	0	110	0.00%	0	110	0.00%	0	110	0.00%
11	Overall	381	497	43.39%	0	878	0.00%	0	878	0.00%	0	878	0.00%
12
13
14
15	CONTACT TYPE (Sales-I / Quotation / Sales Order)
16	Employee	Q1 Contacted	Q1 Not Contacted	Q1 Performance	Q2 Contacted	Q2 Not Contacted	Q2 Performance	Q3 Contacted	Q3 Not Contacted	Q3 Performance	Q4 Contacted	Q4 Not Contacted	Q4 Performance
17	Alina	73	96	43.20%	0	169	0.00%	0	169	0.00%	0	169	0.00%
18	Harriet	70	41	63.06%	0	111	0.00%	0	111	0.00%	0	111	0.00%
19	Jemma	48	63	43.24%	0	111	0.00%	0	111	0.00%	0	111	0.00%
20	Jo	28	82	25.45%	0	110	0.00%	0	110	0.00%	0	110	0.00%
21	Mita	15	31	32.61%	0	46	0.00%	0	46	0.00%	0	46	0.00%
22	Paul	57	53	51.82%	0	110	0.00%	0	110	0.00%	0	110	0.00%
23	Tendayi	48	63	43.24%	0	111	0.00%	0	111	0.00%	0	111	0.00%
24	Zoe	42	68	38.18%	0	110	0.00%	0	110	0.00%	0	110	0.00%
25	Overall	381	497	43.39%	0	878	0.00%	0	878	0.00%	0	878	0.00%
26
27
28		Alina	Harriet	Jemma	Jo	Mita	Paul	Tendayi	Zoe
29	Sales-i	34
30	Sales Quote	102
31	Sales Order	245
32	Telephone Call	0
33	Visit - Pre-made appointments	0
34	Visit - Proactive / Cold Call	0
35	Visit - Reactive	0
Statistics

Cell Formulas
Range	Formula
B3:B10,B17,B19:B24	B3	=SUMPRODUCT(--(WO_Bronze!J:J=Statistics!A3)*(WO_Bronze!N:N="Complete"))
C3:C10,C17:C24	C3	=SUMPRODUCT(--(WO_Bronze!J:J=Statistics!A3)*(WO_Bronze!N:N="No"))
D3:D10,D17:D24	D3	=B3/COUNTIF(WO_Bronze!J:J,Statistics!A3)
E3:E10,E17:E24	E3	=SUMPRODUCT(--(WO_Bronze!J:J=Statistics!A3)*(WO_Bronze!R:R="Complete"))
F3:F10,F17:F24	F3	=SUMPRODUCT(--(WO_Bronze!J:J=Statistics!A3)*(WO_Bronze!R:R="No"))
G3:G10,J3:J10,M3:M10,G17:G24,J17:J24,M17:M24	G3	=E3/F3
H3,H17	H3	=SUMPRODUCT(--(WO_Bronze!J:J=Statistics!A3)*(WO_Bronze!V:V="Complete"))
I3:I10,I17:I24	I3	=SUMPRODUCT(--(WO_Bronze!J:J=Statistics!A3)*(WO_Bronze!V:V="No"))
K3:K10,K17:K24	K3	=SUMPRODUCT(--(WO_Bronze!J:J=Statistics!A3)*(WO_Bronze!Z:Z="Complete"))
L3:L10,L17:L24	L3	=SUMPRODUCT(--(WO_Bronze!J:J=Statistics!A3)*(WO_Bronze!Z:Z="No"))
H4:H10,H18:H24	H4	=SUMPRODUCT(--(WO_Bronze!N:N=Statistics!F4)*(WO_Bronze!R:R="Complete"))
B11:C11,E11:F11,H11:I11,K11:L11,B25:C25,E25:F25,H25:I25,K25:L25	B11	=SUM(B3:B10)
D11,G11,J11,M11,D25,G25,J25,M25	D11	=B11/SUM(B11:C11)
B18	B18	=SUMPRODUCT(--(WO_Bronze!J:J=Statistics!A18)*(WO_Bronze!N:N="Complete"))
B29:B35	B29	=SUMPRODUCT(--(YTD_Figures!E:E=Statistics!A29)*(WO_Bronze!N:N="Complete"))
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[awoohaw]

In the worksheet YTD_Figures where are Sales-i or Sales Quotes? where are the names in reference to the data? I mini worksheet of that would be very helpful.