Sumif/Sumproduct with non-continuous row

[Goddess]

Hi,

I have few tables with a break in row in between the tables:

Book1
	A	B	C	D	E	F	G	H	I	J
1	Country	Thailand
2	Item	Car
3	Colour	Red				Car	Red	7	0
4	Jan						Blue		0
5	Feb	5					Green	9	0
6	Mar						Total	16
7	Apr					Bike	Red	12	0
8	May						Blue	11	0
9	Jun						Green		0
10	Jul	2					Total	23
11	Aug
12	Sep
13	Oct
14	Nov
15	Dec
16	Total	7
17
18	Country	Thailand
19	Item	Bike
20	Colour	Blue
21	Jan
22	Feb
23	Mar
24	Apr	6
25	May
26	Jun
27	Jul
28	Aug	5
29	Sep
30	Oct
31	Nov
32	Dec
33	Total	11
34
35	Country	Thailand
36	Item	Bike
37	Colour	Red
38	Jan
39	Feb	1
40	Mar	2
41	Apr	9
42	May
43	Jun
44	Jul
45	Aug
46	Sep
47	Oct
48	Nov
49	Dec
50	Total	12
51
52	Country	Thailand
53	Item	Car
54	Colour	Green
55	Jan
56	Feb
57	Mar
58	Apr
59	May
60	Jun
61	Jul	9
62	Aug
63	Sep
64	Oct
65	Nov
66	Dec
67	Total	9
Sheet1

Cell Formulas
Range	Formula
H3	H3	=B16
I3:I5,I9	I3	=SUMIFS($B$16:$B$67,$B$2:$B$53,$F$3,$B$3:$B$54,$G3,$B$16:$B$67,$G$6)
H5	H5	=B67
H6,H10	H6	=SUM(H3:H5)
H7	H7	=B50
H8	H8	=B33
I7:I8	I7	=SUMIFS($B$16:$B$67,$B$2:$B$53,$F$7,$B$3:$B$54,$G7,$B$16:$B$67,$G$10)
B16,B67,B50,B33	B16	=SUM(B4:B15)

The result I want is in H3:H10. I tried Sumifs and Sumproduct, but the returned value is 0 (Green cells). Can anyone advise?

Thanks!

 

[Phuoc]

Try this in H3:

=IFERROR(SUM(OFFSET($B$3,MATCH($F$3&G3,$B$2:$B$67&$B$3:$B$68,0),0,12,1)),"")

 

[Goddess]

Try this in H3:

=IFERROR(SUM(OFFSET($B$3,MATCH($F$3&G3,$B$2:$B$67&$B$3:$B$68,0),0,12,1)),"")

Thanks so much!