Need help in Formula

[deepakga123]

I have below table where in the 2nd column I have used sumif formula to get the data from further below table where I used the range as column 6th critera from colum 6 and sum range from 8th.
Now I wanted the formula in column in column 10 where I want colum 8 gets divided with the another table from wher i got the sumif data

	NG DC	Sum If
	11795732	17654.12
	13926732	17654.12
	36634032	9136.02
	44279132	17654.12
	11795761	26118.91
	13926761	26118.91
	36634061	17330.99
	44279161	26118.91
	54811361	17321.03
	54811332	8518.1
	60157332	8518.1
	72386432	8518.1
	94810332	8518.1
NG	Str #	Prov	DC #	NG Str	NG DC	Wave 1 &2 SPAT Plan	Store SELL $ 2013	Store SELL $ 2014	Pro Rata	Distro	DC OH as on 1/22/2015
117957	1520	BC	32	1179571520	11795732	770	9136.02	0			770
139267	1520	BC	32	1392671520	13926732	616	9136.02	0			616
366340	1520	BC	32	3663401520	36634032	311	9136.02	0			311
442791	1520	BC	32	4427911520	44279132	616	9136.02	0			616
117957	1033	ONT	61	1179571033	11795761	650	8797.88	0			650
139267	1033	ONT	61	1392671033	13926761	520	8797.88	0			520
366340	1033	ONT	61	3663401033	36634061	209	8797.88	0			209
442791	1033	ONT	61	4427911033	44279161	520	8797.88	0			520
117957	1071	ONT	61	1179571071	11795761	650	8787.92	0			650
139267	1071	ONT	61	1392671071	13926761	520	8787.92	0			520
442791	1071	ONT	61	4427911071	44279161	520	8787.92	0			520
548113	1071	ONT	61	5481131071	54811361	1300	8787.92	0			1300
117957	379	ATL	61	117957379	11795761	650	8533.11	0			650
139267	379	ATL	61	139267379	13926761	520	8533.11	0			520
366340	379	ATL	61	366340379	36634061	209	8533.11	0			209
442791	379	ATL	61	442791379	44279161	520	8533.11	0			520
548113	379	ATL	61	548113379	54811361	1300	8533.11	0			1300
117957	1517	BC	32	1179571517	11795732	770	8518.1	0			770
139267	1517	BC	32	1392671517	13926732	616	8518.1	0			616
442791	1517	BC	32	4427911517	44279132	616	8518.1	0			616
548113	1517	BC	32	5481131517	54811332	1540	8518.1	0			1540
601573	1517	BC	32	6015731517	60157332	1540	8518.1	0			1540
723864	1517	BC	32	7238641517	72386432	1763	8518.1	0			1763
948103	1517	BC	32	9481031517	94810332	2034	8518.1	0			2034

<colgroup><col style="width: 48pt;" span="4" width="64"> <col style="width: 58pt; mso-width-source: userset; mso-width-alt: 2816;" width="77"> <col style="width: 54pt; mso-width-source: userset; mso-width-alt: 2633;" width="72"> <col style="width: 48pt;" span="4" width="64"> <col style="width: 45pt; mso-width-source: userset; mso-width-alt: 2194;" width="60"> <col style="width: 48pt;" width="64"> <tbody>
</tbody>