SUMIF with segmented array

[just_jon]

Problem: Raw data for ~400 items, with ~20 codes per item, in about 50k rows on 1 sheet as below -- the columns have been reshuffled and many deleted to fit the Html --

foox.XLS
	A	B	C	D	E	F	G	H	I	J
1	Item#	Code	SortKey	EXTQTY/EI	SU	Urun	Erun	TotLbr	U/P	ExtUP
2	0701	XX1	0701-XX1	1		.0000			$384.7790	$384.78
3	0701	YY1	0701-YY1	2	8.5789	1.0910	2.1820	10.7609	$-	$-
4	0825	XX1	0825-XX1	3		.0000			$0.0130	$0.04
5	0825	XX1	0825-XX1	1		.0000			$0.0480	$0.05
6	0825	YY2	0825-YY2	1	.0000	.8480	.8480	.8480	$-	$-
7	0825	YY2	0825-YY2	3	.0000	.7330	2.1990	2.1990	$-	$-
8	0834	XX1	0834-XX1	0.1		.0000			$0.1940	$0.02
9	0834	XX2	0834-XX2	0.1		.0000			$0.2240	$0.02
10	0834	XX2	0834-XX2	2		.0000			$0.0250	$0.05
11	1051	XX2	1051-XX2	4		.0000			$0.5000	$2.00
GB

Data is sorted by SortKey. The below is how I intend to go about accumulating the raw data into single-row data by Item # --

See next post...

 

[just_jon]

foox.XLS
	A	B	C	D	E	F	G	H
31			Materials		Labor
32	Iten#	P/N	XX1	XX2	YY1	YY2	Start	Stop
33	0701	Blah	$384.78	$-	10.761	-	2	3
34	0825	Blah	$0.09	$-	-	3.047	3	6
35	0834	Blah	$0.02	$0.07	-	-	6	8
36	1051	Blah	$-	$2.00	-	-	8	8
Data

The qustion is -- is there a better way?
in C33: =IF(ISNA(G33),0,SUMIF(INDEX(GB!$C:$C,G33):INDEX(GB!$C:$C,H33),"="&$A33&"-"&C$32,INDEX(GB!$J:$J,G33):INDEX(GB!$J:$J,H33)))
in G33: =MATCH(A33,GB!A1:A11,0)
in H33: =MATCH(A33,GB!A1:A11)

Aladin -- have I followed the example in the BlackSwan topic well?