I was able to develop a formula to capture the correct emission (tons column) on the Engine Evaluation worksheet for pollutant NOX and engine type PW4090 at the first table approx C15:G26, but do not know how to extend to sum from all tables.

So at J17 on the Evaluation Summary I came up with:

Code:

`[COLOR=#222222][FONT=Calibri][SIZE=3]=INDEX('Engine Evaluation'!B15:L26,MATCH(J15,'Engine Evaluation'!B15:B26,0),MATCH(I17,'Engine Evaluation'!B15:H15,0)+4)[/SIZE][/FONT][/COLOR]`

Alternatively:

Code:

`[COLOR=#222222][FONT=Calibri]=SUM(IF(('Engine Evaluation'!$B$22:$B$26=J15)*('Engine Evaluation'!$C$15:$F$15=I17),'Engine Evaluation'!$G$22:$G$26,0))[/FONT][/COLOR]`

Both give the correct answer but again, I don’t know how to extend the formulas to the other tables. Below the table with the one formula at J17 is an image of the table with a few of the expected results.

Please see tables at:https://dl.dropboxusercontent.com/u/95483456/Excel/DWGN%20Evaluation6.xls

Your help would be most appreciated. Excel 2003.