Access with formulas and fetch values

[rsingh4377]

BIN	ELEMENT#	TTL	LV2	LV3	LV4
1234	12	200	150	50	0
1234	13	150	130	10	10
1234	15	350	350
1234	18	10	10
1234	201	255	255
1234	340	30	25		5
1

<tbody>
</tbody>

Secondarytable ^
main tbl ex. below

BIN	ELEMENT X 0-100	ELEMENT Y100-200	ELEMENT Z 200-400
1234	9.86		1.75
1235
1236
1237
1238
1239
1240

<tbody>
</tbody>

Hi, I am attempting to create a formula in excel in which Ican perform a simple mathematical operation by picking through certain criteriafrom data on another sheet. However, there are duplicate entries on the sheetfrom which I need to reference. For example, I have a main excel sheet where Ihave several columns set up to display a percentage of each element of a bridge’sconstruction with each row being referenced to with a BIN number. I am tryingto pull data from a secondary sheet in which the element number is in its owncolumn resulting in multiple rows with the same BIN number. Further on the secondarysheet is the data in which I need to extract a calculation in which I find thepercentage makeup of levels 3 and 4 from the entire sq ft of the element. However,there are multiple element’s numbers included in one element group, thereforethere can be several entries for each element group in addition to severalentries for other element groups. For example, say from a list of 20,000entries on the secondary table, I am searching only for BIN number 1234 forelement x and the element numbers associated with this element group are 5, 6and 7. In an equation, I need to find a way to 1) find BIN number 1234 2) find specificallyelments 5, 6 and 7 while accounting for the fact that there may not be any datafor these elements 3) find the sum of the total sq ft (which would be in itsown column) and find the sum of levels 3 and 4 (which are also in their owncolumns respectively) and perform a calculation with this data. PLEASE HELP!