ARRAYFORUMLA and SUMIF

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U
1			UNIT 1	UNIT 1	UNIT 1	UNIT 1	UNIT 2	UNIT 2	UNIT 2	UNIT 3	UNIT 3	UNIT 3	UNIT 3	UNIT 4	UNIT 4	UNIT 4	UNIT 4	UNIT 4	UNIT 5	UNIT 5	UNIT 5
2	PART NUMBER	PROJECT TOTAL	TOTAL	DRAWING 1	DRAWING 2	DRAWING 3	TOTAL	DRAWING 4	DRAWING 5	TOTAL	DRAWING 6	DRAWING 7	DRAWING 8	TOTAL	DRAWING 8	DRAWING 9	DRAWING 10	DRAWING 11	TOTAL	DRAWING 12	DRAWING 13
3	PN1	20	14	7	7		1		1	0				4		4			1		1
4	PN2	20	14	7	7		1		1	0				4		4			1		1
5	PN3	14	0				6		6	0				3		3			5		5
6	PN4	0	0				0			0				0					0
7	PN5	48	14	7	7		12		12	0				10		10			12		12
8	PN6	36	0				12	12		0				12	12				12	12
9	PN7	16	4				4			0				4			4		4
10	PN8	18	0				6	6		0				6	6				6	6
11	PN9	125	50	25	25		25		25	0				25		25			25		25
12	PN10	0	0				0			0				0					0
13	PN11	100	25		25		25		25	0				25		25			25		25
14	PN12	100	25		25		25		25	0				25		25			25		25
15	PN13	250	100	50	50		50		50	0				50		50			50		50
16	PN14	2	0				0			2				0					0
17	PN15	300	56	28	28		84	36	48	0				76	36	40			84	36	48
18	PN16	8	2				2			0				2					2
19	PN17	12	0				4	4		0				4	4				4	4
20	PN18	4	0				0			4	4			0					0
21	PN19	0	0				0			0				0					0
22	PN20	0	0				0			0				0					0
23	PN21	0	0				0			0				0					0
24	PN22	306	4				78	74		68	12	56		78	74		4		78	74
25	PN23	6	0				2	2		0				2	2				2	2
26	PN24	4	0				0			4		4		0					0
27	PN25	36	0				12	12		0				12	12				12	12
28	PN26	4	0				0			4				0					0
29	PN27	0	0				0			0				0					0
30	PN28	164	59	24	35		35		35	0				35		35			35		35
31	PN29	296	104	52	52		62		62	12	12			58		58			60		60
32	PN30	8	2			2	2			0				2				2	2
33	PN31	9	2			2	2			1				2				2	2
34	PN32	2	0				0			2				0					0
35	PN33	0	0				0			0				0					0
36	PN34	21	4			4	4			5				4				4	4
37	PN35	10	4	2	2		2		2	0				2		2			2		2
38	PN36	0	0				0			0				0					0
39	PN37	1	0				0			1	1			0					0
40	PN38	74	24	12	12		18		18	0				15		15			17		17
41	PN39	24	8	4	4		4		4	4	4			4		4			4		4
42	PN40	0	0				0			0				0					0
43	PN41	1	0				0			1	1			0					0
44	PN42	1	0				0			1	1			0					0
45	PN43	1	0				0			1	1			0					0
46	PN44	0	0				0			0				0					0
47	PN45	0	0				0			0				0					0
48	PN46	0	0				0			0				0					0
49	PN47	0	0				0			0				0					0
50	PN48
51	PN49	0	0				0			0				0					0
52	PN50	0	0				0			0				0					0
53	PN51	1	0				0			1	1			0					0
54	PN52	0	0				0			0				0					0
55	PN53	0	0				0			0				0					0
56	PN54	0	0				0			0				0					0
57	PN55	1	0				0			1	1			0					0
58	PN56	20	8	4	4		4		4	0				4		4			4		4
59	PN57	0	0				0			0				0					0
60	PN58	0	0				0			0				0					0
61	PN59	43	8			8	8			11				8				8	8
62	PN60	0	0				0			0				0					0
63	PN61	2	0				0			2				0					0
64	PN62	0	0				0			0				0					0
65	PN63	10	2			2	2			2				2				2	2
66	PN64	12	3			3	3			0				3				3	3
67	PN65	12	3			3	3			0				3				3	3
68	PN66	32	8			8	8			0				8				8	8
69	PN67	14	2			2	2			6				2				2	2
70	PN68	25	0				0			25				0					0
71	PN69	187	45			45	45			7				45				45	45
72	PN70	62	13			13	13			10				13				13	13
73	PN71	12	3			3	3			0				3				3	3
74	PN72	3	0				0			3				0					0
75	PN73	33	8			8	8			1				8				8	8
76	PN74	9	2			2	2			1				2				2	2
77	PN75	24	6			6	6			0				6				6	6
78	PN76	0	0				0			0				0					0
79	PN77	0	0				0			0				0					0
80	PN78	8	2			2	2			0				2				2	2
81	PN79	1	0				0			1	1			0					0
82	PN80	4	0				0			4	4			0					0
83	PN81	0	0				0			0				0					0
84	PN82	0	0				0			0				0					0
85	PN83	0	0				0			0				0					0
86	PN84	0	0				0			0				0					0
87	PN85	2	0				0			2			1	0					0
88	PN86	4	1			1	1			0				1				1	1
89	PN87	13	3			3	3			1				3				3	3
90	PN88	444	159	64	95		95		95	0				95		95			95		95
91	PN89	132	48	24	24		24		24	12	12			24		24			24		24
92	PN90	0	0				0			0				0					0
93	PN91	0	0				0			0				0					0
94	PN92	0	0				0			0				0					0
95	PN93	8	2				2			0				2			2		2
96	PN94	0	0				0			0				0					0
97	PN95	20	14	7	7		1		1	0				4		4			1		1
98	PN96	14	0				6		6	0				3		3			5		5
99	PN97	0	0				0			0				0					0
100	PN98	1	0				0			1		1		0					0