How can I write a Formula to do this.....

[alsexceladmin]

Formula teeth gnasher.xls
	A	B	C	D	E	F	G	H	I	J	K	L	M
1	Spreadsheet			Range1
2	Ben	Site		IndividualSites	IS	JSA-6	NONE
3	IS	Crumpsall		Charlestown	18	14	14
4	JSA-6	Harpurhey		Crumpsall	18	14	14
5	NONE	Harpurhey		Harpurhey	18	14	14
6
7				Range2
8				LADVALUES	IS	JSA-6	NONE
9				Cheetham	6	2	2
10				Harpurhey	6	2	2
11				Bradford	6	2	2
12
13	Fromabovespreadsheet,howdoIcreateaformulatoproduceanumberedresultinagivencellforthefollowingexample:
14	Identifyindividualcellcontentof"A3"and"B3"(bothtext)respectively,thenmatchbothcriteriainRange"D2:G5"-
15	toproducethenumberresultofintersectingcells"E4"
16	Cellcontentin"A3","B3"comboappliedtoRange1sheetwouldgivearesultof18,similarlywith"A4","B4"combowouldgive14.
17	IalsoneedtoapplyasimilarformulatoRange2,thenaddthetworesultstogetherinagivencell.
Sheet1

 

[alsexceladmin]

Sean - Your a star!
Thanks for the time you have put in on this for me, it now works a treat.
Also thanking all other contributors, Ken,Chiello etc.
Much appreciated - thanks Gang!

Alsexceladmin