Need Help Summing Two Way Lookups from Multiple Tables

[dwgnome]

Looking to sum the total emissions from several tables based on two criteria – the engine type and pollutant. However, each emission table is “labeled” by the engine type from a drop down (at C15, H15, Q15, V15 etc) and can change based on user input.

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:

[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:

[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]

as Cntrl+Shft+Enter

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.

 

[dwgnome]

Please see interesting SUMIF and SUMPRODUCT approaches developed at this x-post link:

Need to Sum from Multiple Tables

Is it still possible to have a formula approach without helper columns?

 

[Aladin Akyurek]

Is it possible that you just have 2 small tables posted here along with the expected results (manually calculated), colored say in light blue, without a reference to any formula whatsoever?

 

[dwgnome]

Do you mean these two?


Evaluation Summary

*	I	J	K	L	M	N
*

<colgroup><col style="font-weight:bold; width:30px; "><col style="width:125px;"><col style="width:82px;"><col style="width:82px;"><col style="width:82px;"><col style="width:82px;"><col style="width:82px;"></colgroup><tbody>
[TD="bgcolor: #cacaca, align: center"]15[/TD]

[TD="align: center"]NOX[/TD]
[TD="align: center"]CO[/TD]
[TD="align: center"]POC[/TD]
[TD="align: center"]SO2[/TD]
[TD="align: center"]PM[/TD]

[TD="bgcolor: #cacaca, align: center"]16[/TD]
[TD="bgcolor: #ffffcc, align: center"]Engine Type[/TD]
[TD="bgcolor: #ffffcc, align: center"]NOX Emissions (tpy)[/TD]
[TD="bgcolor: #ffffcc, align: center"]CO Emissions (tpy)[/TD]
[TD="bgcolor: #ffffcc, align: center"]POC Emissions (tpy)[/TD]
[TD="bgcolor: #ffffcc, align: center"]SO2 Emissions (tpy)[/TD]
[TD="bgcolor: #ffffcc, align: center"]PM Emissions (tpy)[/TD]

[TD="bgcolor: #cacaca, align: center"]17[/TD]
[TD="align: left"]PW4090[/TD]
[TD="align: center"]8.83[/TD]
[TD="align: center"]0.691[/TD]
[TD="align: center"]0.000[/TD]
[TD="align: center"]0.089[/TD]
[TD="align: center"]0.370[/TD]

[TD="bgcolor: #cacaca, align: center"]18[/TD]
[TD="align: left"]PW4077[/TD]
[TD="align: center"]1.924[/TD]
[TD="align: center"]0.200[/TD]
[TD="align: center"]0.000[/TD]
[TD="align: center"]0.027[/TD]
[TD="align: center"]0.112[/TD]

[TD="bgcolor: #cacaca, align: center"]19[/TD]
[TD="align: left"]PW4060[/TD]
[TD="align: center"]0.365[/TD]
[TD="align: center"]0.054[/TD]
[TD="align: center"]0.000[/TD]
[TD="align: center"]0.006[/TD]
[TD="align: center"]0.026[/TD]

[TD="bgcolor: #cacaca, align: center"]20[/TD]
[TD="align: left"]PW2000[/TD]
[TD="align: center"]0.435[/TD]
[TD="align: center"]0.058[/TD]
[TD="align: center"]0.000[/TD]
[TD="align: center"]0.007[/TD]
[TD="align: center"]0.030[/TD]

[TD="bgcolor: #cacaca, align: center"]21[/TD]
[TD="align: left"]CFM563C[/TD]
[TD="align: center"]0.039[/TD]
[TD="align: center"]0.012[/TD]
[TD="align: center"]0.000[/TD]
[TD="align: center"]0.001[/TD]
[TD="align: center"]0.004[/TD]

[TD="bgcolor: #cacaca, align: center"]22[/TD]
[TD="align: left"]F_117[/TD]
[TD="align: center"]1.309[/TD]
[TD="align: center"]0.174[/TD]
[TD="align: center"]0.000[/TD]
[TD="align: center"]0.022[/TD]
[TD="align: center"]0.090[/TD]

[TD="bgcolor: #cacaca, align: center"]23[/TD]
[TD="align: left"]JT9D[/TD]
[TD="align: center"]0.0[/TD]
[TD="align: center"]0.0[/TD]
[TD="align: center"]0.00[/TD]
[TD="align: center"]0.00[/TD]
[TD="align: center"]0.00[/TD]

[TD="bgcolor: #cacaca, align: center"]24[/TD]
[TD="bgcolor: #ffffcc, align: right"]Total[/TD]
[TD="align: center"]12.91[/TD]
[TD="align: center"]1.19[/TD]
[TD="align: center"]0.00[/TD]
[TD="align: center"]0.15[/TD]
[TD="align: center"]0.63[/TD]

</tbody>

Excel tables to the web >> Excel Jeanie HTML 4

Engine Evaluation

*	B	C	D	E	F	G	H	I	J	K	L
*
*
*
*
*
*
*

<colgroup><col style="font-weight:bold; width:30px; "><col style="width:107px;"><col style="width:92px;"><col style="width:93px;"><col style="width:89px;"><col style="width:85px;"><col style="width:89px;"><col style="width:85px;"><col style="width:80px;"><col style="width:84px;"><col style="width:85px;"><col style="width:91px;"></colgroup><tbody>
[TD="bgcolor: #cacaca, align: center"]4[/TD]

[TD="bgcolor: #ffffcc"]ENGINE MODEL[/TD]
[TD="bgcolor: #ffffcc"]*[/TD]
[TD="bgcolor: #ffffcc"]*[/TD]
[TD="bgcolor: #ffffcc"]*[/TD]
[TD="bgcolor: #ffffcc"]*[/TD]
[TD="bgcolor: #ffffcc"]*[/TD]
[TD="bgcolor: #ffffcc"]*[/TD]
[TD="bgcolor: #ffffcc"]*[/TD]
[TD="bgcolor: #ffffcc"]*[/TD]
[TD="bgcolor: #ffffcc"]*[/TD]

[TD="bgcolor: #cacaca, align: center"]5[/TD]

[TD="bgcolor: #ffffcc"]PW4090[/TD]
[TD="bgcolor: #ffffcc"]*[/TD]
[TD="bgcolor: #ffffcc"]*[/TD]
[TD="bgcolor: #ffffcc"]*[/TD]
[TD="bgcolor: #ffffcc"]# Tested[/TD]
[TD="bgcolor: #ffffcc"]PW4077[/TD]
[TD="bgcolor: #ffffcc"]*[/TD]
[TD="bgcolor: #ffffcc"]*[/TD]
[TD="bgcolor: #ffffcc"]*[/TD]
[TD="bgcolor: #ffffcc"]# Tested[/TD]

[TD="bgcolor: #cacaca, align: center"]6[/TD]

[TD="bgcolor: #ffffcc, align: center"]Idle[/TD]
[TD="bgcolor: #ffffcc, align: center"]Approach[/TD]
[TD="bgcolor: #ffffcc, align: center"]Climbout[/TD]
[TD="bgcolor: #ffffcc, align: center"]Takeoff[/TD]
[TD="bgcolor: #ffffcc, align: center"]3[/TD]
[TD="bgcolor: #ffffcc, align: center"]Idle[/TD]
[TD="bgcolor: #ffffcc, align: center"]Approach[/TD]
[TD="bgcolor: #ffffcc, align: center"]Climbout[/TD]
[TD="bgcolor: #ffffcc, align: center"]Takeoff[/TD]
[TD="bgcolor: #ffffcc, align: center"]2[/TD]

[TD="bgcolor: #cacaca, align: center"]7[/TD]

[TD="bgcolor: #ffffcc"]Fuel Usage @ Power Setting (gal)[/TD]
[TD="bgcolor: #ffffcc"]*[/TD]
[TD="bgcolor: #ffffcc"]*[/TD]
[TD="bgcolor: #ffffcc"]*[/TD]
[TD="bgcolor: #ffffcc, align: center"]Total (gals)[/TD]
[TD="bgcolor: #ffffcc"]Fuel Usage @ Power Setting (gal)[/TD]
[TD="bgcolor: #ffffcc"]*[/TD]
[TD="bgcolor: #ffffcc"]*[/TD]
[TD="bgcolor: #ffffcc"]*[/TD]
[TD="bgcolor: #ffffcc, align: center"]Total (gals)[/TD]

[TD="bgcolor: #cacaca, align: center"]8[/TD]

[TD="bgcolor: #ccffcc, align: center"]1,762[/TD]
[TD="bgcolor: #ccffcc, align: center"]1,384[/TD]
[TD="bgcolor: #ccffcc, align: center"]5,663[/TD]
[TD="bgcolor: #ccffcc, align: center"]3,775[/TD]
[TD="bgcolor: #ffffcc, align: center"]12,584[/TD]
[TD="bgcolor: #ccffcc, align: center"]1,070[/TD]
[TD="bgcolor: #ccffcc, align: center"]841[/TD]
[TD="bgcolor: #ccffcc, align: center"]3,441[/TD]
[TD="bgcolor: #ccffcc, align: center"]2,294[/TD]
[TD="bgcolor: #ffffcc, align: center"]7,646[/TD]

[TD="bgcolor: #cacaca, align: center"]9[/TD]

[TD="bgcolor: #ffffcc"]Fuel Usage @ Power Setting (lb)[/TD]
[TD="bgcolor: #ffffcc"]*[/TD]
[TD="bgcolor: #ffffcc"]*[/TD]
[TD="bgcolor: #ffffcc"]*[/TD]
[TD="bgcolor: #ffffcc"]*[/TD]
[TD="bgcolor: #ffffcc"]Fuel Usage @ Power Setting (lb)[/TD]
[TD="bgcolor: #ffffcc"]*[/TD]
[TD="bgcolor: #ffffcc"]*[/TD]
[TD="bgcolor: #ffffcc"]*[/TD]
[TD="bgcolor: #ffffcc"]*[/TD]

[TD="bgcolor: #cacaca, align: center"]10[/TD]

[TD="bgcolor: #ffcc99, align: center"]12,490[/TD]
[TD="bgcolor: #ffcc99, align: center"]9,813[/TD]
[TD="bgcolor: #ffcc99, align: center"]40,145[/TD]
[TD="bgcolor: #ffcc99, align: center"]26,763[/TD]
[TD="bgcolor: #ffffcc"]*[/TD]
[TD="bgcolor: #ffcc99, align: center"]7,588[/TD]
[TD="bgcolor: #ffcc99, align: center"]5,962[/TD]
[TD="bgcolor: #ffcc99, align: center"]24,391[/TD]
[TD="bgcolor: #ffcc99, align: center"]16,261[/TD]
[TD="bgcolor: #ffffcc"]*[/TD]

[TD="bgcolor: #cacaca, align: center"]11[/TD]
[TD="bgcolor: #ffffcc, align: center"]Pollutant[/TD]
[TD="bgcolor: #ffffcc"]Emissions @ Power Setting (lb)[/TD]
[TD="bgcolor: #ffffcc"]*[/TD]
[TD="bgcolor: #ffffcc"]*[/TD]
[TD="bgcolor: #ffffcc"]*[/TD]
[TD="bgcolor: #ffffcc, align: center"]Total (tons)[/TD]
[TD="bgcolor: #ffffcc"]Emissions @ Power Setting (lb)[/TD]
[TD="bgcolor: #ffffcc"]*[/TD]
[TD="bgcolor: #ffffcc"]*[/TD]
[TD="bgcolor: #ffffcc"]*[/TD]
[TD="bgcolor: #ffffcc, align: center"]Total (tons)[/TD]

[TD="bgcolor: #cacaca, align: center"]12[/TD]
[TD="bgcolor: #ffffcc, align: center"]CO[/TD]
[TD="align: center"]258[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]9[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]0.14[/TD]
[TD="align: center"]153[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]0.08[/TD]

[TD="bgcolor: #cacaca, align: center"]13[/TD]
[TD="bgcolor: #ffffcc, align: center"]VOC[/TD]
[TD="align: center"]29[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]0.02[/TD]
[TD="align: center"]23[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]0.01[/TD]

[TD="bgcolor: #cacaca, align: center"]14[/TD]
[TD="bgcolor: #ffffcc, align: center"]NOX[/TD]
[TD="align: center"]54[/TD]
[TD="align: center"]129[/TD]
[TD="align: center"]1718[/TD]
[TD="align: center"]1633[/TD]
[TD="align: center"]1.77[/TD]
[TD="align: center"]32[/TD]
[TD="align: center"]67[/TD]
[TD="align: center"]793[/TD]
[TD="align: center"]647[/TD]
[TD="align: center"]0.77[/TD]

[TD="bgcolor: #cacaca, align: center"]15[/TD]
[TD="bgcolor: #ffffcc, align: center"]SO2[/TD]
[TD="align: center"]5.0[/TD]
[TD="align: center"]3.9[/TD]
[TD="align: center"]16[/TD]
[TD="align: center"]11[/TD]
[TD="align: center"]0.018[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]0.01[/TD]

[TD="bgcolor: #cacaca, align: center"]16[/TD]
[TD="bgcolor: #ffffcc, align: center"]PM[/TD]
[TD="align: center"]20.73[/TD]
[TD="align: center"]16[/TD]
[TD="align: center"]67[/TD]
[TD="align: center"]44[/TD]
[TD="align: center"]0.07[/TD]
[TD="align: center"]13[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]40[/TD]
[TD="align: center"]27[/TD]
[TD="align: center"]0.04[/TD]

</tbody>

Excel tables to the web >> Excel Jeanie HTML 4

Otherwise I think you have access to the actual file and can pull the tables you are requesting.

Sorry if I am not understanding. Thanks for helping.

 

[Aladin Akyurek]

Do you mean these two?

...

Otherwise I think you have access to the actual file and can pull the tables you are requesting.

Sorry if I am not understanding. Thanks for helping.

You dropbox file is filled up with formulas and no indication where a formula is needed and what for. The trouble is with "see the file" is that it asks for a long study and a tenuous correlation with what has been said on the board itself.

A better strategy is that the problem owner (that's you) reduces the problem to its bare bones, creates a small example sample, state clearly what the desired results are (preferably done manually and, say, colored light blue), and offers no formula(s) for solution at all. If there is a set of problems, try to do them by one one, not all at once. Tip. Only NOX and CO should suffice as this set appears to be illustrative of the problem you appear to have.

 

[dwgnome]

Okay, I will try to explain.

I have many tables (Engine Evaluation tab) arranged side by side going down a worksheet from which I am needing to sum the total tons in column G that match the pollutant type for a given engine type (i.e., match NOX for PW4090). Using just the tables shown and not the referenced file in the earlier post. The value for NOX for PW4090 is 1.77, that value should be in cell J17 of the summary table (blue shaded cell). Since the engine type can change, and therefore be repeated (i.e., PW4090 and PW4077 are shown but can easily be PW4090 and PW4090), the corresponding value in the tons column need to be summed.

Evaluation Summary

*	I	J	K	L	M	N
*

<tbody>
[TD="bgcolor: #cacaca, align: center"]15[/TD]

[TD="align: center"]NOX[/TD]
[TD="align: center"]CO[/TD]
[TD="align: center"]POC[/TD]
[TD="align: center"]SO2[/TD]
[TD="align: center"]PM[/TD]

[TD="bgcolor: #cacaca, align: center"]16[/TD]
[TD="bgcolor: #ffffcc, align: center"]Engine Type[/TD]
[TD="bgcolor: #ffffcc, align: center"]NOX Emissions (tpy)[/TD]
[TD="bgcolor: #ffffcc, align: center"]CO Emissions (tpy)[/TD]
[TD="bgcolor: #ffffcc, align: center"]POC Emissions (tpy)[/TD]
[TD="bgcolor: #ffffcc, align: center"]SO2 Emissions (tpy)[/TD]
[TD="bgcolor: #ffffcc, align: center"]PM Emissions (tpy)[/TD]

[TD="bgcolor: #cacaca, align: center"]17[/TD]
[TD="align: left"]PW4090[/TD]
[TD="bgcolor: #99ccff, align: right"]1.77[/TD]
[TD="align: right"]0.14[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.02[/TD]
[TD="align: right"]0.07[/TD]

[TD="bgcolor: #cacaca, align: center"]18[/TD]
[TD="align: left"]PW4077[/TD]
[TD="align: right"]0.77[/TD]
[TD="align: right"]0.08[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.01[/TD]
[TD="align: right"]0.04[/TD]

[TD="bgcolor: #cacaca, align: center"]19[/TD]
[TD="align: left"]PW4060[/TD]
[TD="align: right"]0.36[/TD]
[TD="align: right"]0.05[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.01[/TD]
[TD="align: right"]0.03[/TD]

[TD="bgcolor: #cacaca, align: center"]20[/TD]
[TD="align: left"]PW2000[/TD]
[TD="align: right"]0.44[/TD]
[TD="align: right"]0.06[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.01[/TD]
[TD="align: right"]0.03[/TD]

[TD="bgcolor: #cacaca, align: center"]21[/TD]
[TD="align: left"]CFM563C[/TD]
[TD="align: right"]0.04[/TD]
[TD="align: right"]0.01[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]

[TD="bgcolor: #cacaca, align: center"]22[/TD]
[TD="align: left"]F_117[/TD]
[TD="align: right"]1.31[/TD]
[TD="align: right"]0.17[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.02[/TD]
[TD="align: right"]0.09[/TD]

[TD="bgcolor: #cacaca, align: center"]23[/TD]
[TD="align: left"]JT9D[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]

[TD="bgcolor: #cacaca, align: center"]24[/TD]
[TD="bgcolor: #ffffcc, align: right"]Total[/TD]
[TD="align: center"]4.68[/TD]
[TD="align: center"]0.52[/TD]
[TD="align: center"]0.00[/TD]
[TD="align: center"]0.06[/TD]
[TD="align: center"]0.27[/TD]

</tbody>

Excel tables to the web >> Excel Jeanie HTML 4




Engine Evaluation

*	B	C	D	E	F	G	H	I	J	K	L
*
*
*
*
*
*
*

<tbody>
[TD="bgcolor: #cacaca, align: center"]4[/TD]

[TD="bgcolor: #ffffcc"]ENGINE MODEL[/TD]
[TD="bgcolor: #ffffcc"]*[/TD]
[TD="bgcolor: #ffffcc"]*[/TD]
[TD="bgcolor: #ffffcc"]*[/TD]
[TD="bgcolor: #ffffcc"]*[/TD]
[TD="bgcolor: #ffffcc"]*[/TD]
[TD="bgcolor: #ffffcc"]*[/TD]
[TD="bgcolor: #ffffcc"]*[/TD]
[TD="bgcolor: #ffffcc"]*[/TD]
[TD="bgcolor: #ffffcc"]*[/TD]

[TD="bgcolor: #cacaca, align: center"]5[/TD]

[TD="bgcolor: #99ccff, align: left"]PW4090[/TD]
[TD="bgcolor: #ffffcc"]*[/TD]
[TD="bgcolor: #ffffcc"]*[/TD]
[TD="bgcolor: #ffffcc"]*[/TD]
[TD="bgcolor: #ffffcc, align: left"]# Tested[/TD]
[TD="bgcolor: #99ccff, align: left"]PW4077[/TD]
[TD="bgcolor: #ffffcc"]*[/TD]
[TD="bgcolor: #ffffcc"]*[/TD]
[TD="bgcolor: #ffffcc"]*[/TD]
[TD="bgcolor: #ffffcc, align: left"]# Tested[/TD]

[TD="bgcolor: #cacaca, align: center"]6[/TD]

[TD="bgcolor: #ffffcc, align: center"]Idle[/TD]
[TD="bgcolor: #ffffcc, align: center"]Approach[/TD]
[TD="bgcolor: #ffffcc, align: center"]Climbout[/TD]
[TD="bgcolor: #ffffcc, align: center"]Takeoff[/TD]
[TD="bgcolor: #ffffcc, align: center"]3[/TD]
[TD="bgcolor: #ffffcc, align: center"]Idle[/TD]
[TD="bgcolor: #ffffcc, align: center"]Approach[/TD]
[TD="bgcolor: #ffffcc, align: center"]Climbout[/TD]
[TD="bgcolor: #ffffcc, align: center"]Takeoff[/TD]
[TD="bgcolor: #ffffcc, align: center"]2[/TD]

[TD="bgcolor: #cacaca, align: center"]7[/TD]

[TD="bgcolor: #ffffcc, align: left"]Fuel Usage @ Power Setting (gal)[/TD]
[TD="bgcolor: #ffffcc"]*[/TD]
[TD="bgcolor: #ffffcc"]*[/TD]
[TD="bgcolor: #ffffcc"]*[/TD]
[TD="bgcolor: #ffffcc, align: left"]Total (gals)[/TD]
[TD="bgcolor: #ffffcc, align: left"]Fuel Usage @ Power Setting (gal)[/TD]
[TD="bgcolor: #ffffcc"]*[/TD]
[TD="bgcolor: #ffffcc"]*[/TD]
[TD="bgcolor: #ffffcc"]*[/TD]
[TD="bgcolor: #ffffcc, align: left"]Total (gals)[/TD]

[TD="bgcolor: #cacaca, align: center"]8[/TD]

[TD="bgcolor: #ccffcc, align: center"]1,762[/TD]
[TD="bgcolor: #ccffcc, align: center"]1,384[/TD]
[TD="bgcolor: #ccffcc, align: center"]5,663[/TD]
[TD="bgcolor: #ccffcc, align: center"]3,775[/TD]
[TD="bgcolor: #ffffcc, align: center"]12,584[/TD]
[TD="bgcolor: #ccffcc, align: center"]1,070[/TD]
[TD="bgcolor: #ccffcc, align: center"]841[/TD]
[TD="bgcolor: #ccffcc, align: center"]3,441[/TD]
[TD="bgcolor: #ccffcc, align: center"]2,294[/TD]
[TD="bgcolor: #ffffcc, align: center"]7,646[/TD]

[TD="bgcolor: #cacaca, align: center"]9[/TD]

[TD="bgcolor: #ffffcc, align: left"]Fuel Usage @ Power Setting (lb)[/TD]
[TD="bgcolor: #ffffcc"]*[/TD]
[TD="bgcolor: #ffffcc"]*[/TD]
[TD="bgcolor: #ffffcc"]*[/TD]
[TD="bgcolor: #ffffcc"]*[/TD]
[TD="bgcolor: #ffffcc, align: left"]Fuel Usage @ Power Setting (lb)[/TD]
[TD="bgcolor: #ffffcc"]*[/TD]
[TD="bgcolor: #ffffcc"]*[/TD]
[TD="bgcolor: #ffffcc"]*[/TD]
[TD="bgcolor: #ffffcc"]*[/TD]

[TD="bgcolor: #cacaca, align: center"]10[/TD]

[TD="bgcolor: #ffcc99, align: center"]12,490[/TD]
[TD="bgcolor: #ffcc99, align: center"]9,813[/TD]
[TD="bgcolor: #ffcc99, align: center"]40,145[/TD]
[TD="bgcolor: #ffcc99, align: center"]26,763[/TD]
[TD="bgcolor: #ffffcc"]*[/TD]
[TD="bgcolor: #ffcc99, align: center"]7,588[/TD]
[TD="bgcolor: #ffcc99, align: center"]5,962[/TD]
[TD="bgcolor: #ffcc99, align: center"]24,391[/TD]
[TD="bgcolor: #ffcc99, align: center"]16,261[/TD]
[TD="bgcolor: #ffffcc"]*[/TD]

[TD="bgcolor: #cacaca, align: center"]11[/TD]
[TD="bgcolor: #ffffcc, align: center"]Pollutant[/TD]
[TD="bgcolor: #ffffcc, align: left"]Emissions @ Power Setting (lb)[/TD]
[TD="bgcolor: #ffffcc"]*[/TD]
[TD="bgcolor: #ffffcc"]*[/TD]
[TD="bgcolor: #ffffcc"]*[/TD]
[TD="bgcolor: #ffffcc, align: left"]Total (tons)[/TD]
[TD="bgcolor: #ffffcc, align: left"]Emissions @ Power Setting (lb)[/TD]
[TD="bgcolor: #ffffcc"]*[/TD]
[TD="bgcolor: #ffffcc"]*[/TD]
[TD="bgcolor: #ffffcc"]*[/TD]
[TD="bgcolor: #ffffcc, align: left"]Total (tons)[/TD]

[TD="bgcolor: #cacaca, align: center"]12[/TD]
[TD="bgcolor: #ffffcc, align: center"]CO[/TD]
[TD="align: center"]258[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]9[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]0.14[/TD]
[TD="align: center"]153[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]0.08[/TD]

[TD="bgcolor: #cacaca, align: center"]13[/TD]
[TD="bgcolor: #ffffcc, align: center"]VOC[/TD]
[TD="align: center"]29[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]0.02[/TD]
[TD="align: center"]23[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]0.01[/TD]

[TD="bgcolor: #cacaca, align: center"]14[/TD]
[TD="bgcolor: #99ccff, align: center"]NOX[/TD]
[TD="align: center"]54[/TD]
[TD="align: center"]129[/TD]
[TD="align: center"]1718[/TD]
[TD="align: center"]1633[/TD]
[TD="bgcolor: #99ccff, align: center"]1.77[/TD]
[TD="align: center"]32[/TD]
[TD="align: center"]67[/TD]
[TD="align: center"]793[/TD]
[TD="align: center"]647[/TD]
[TD="bgcolor: #99ccff, align: center"]0.77[/TD]

[TD="bgcolor: #cacaca, align: center"]15[/TD]
[TD="bgcolor: #ffffcc, align: center"]SO2[/TD]
[TD="align: center"]5.0[/TD]
[TD="align: center"]3.9[/TD]
[TD="align: center"]16[/TD]
[TD="align: center"]11[/TD]
[TD="align: center"]0.018[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]0.01[/TD]

[TD="bgcolor: #cacaca, align: center"]16[/TD]
[TD="bgcolor: #ffffcc, align: center"]PM[/TD]
[TD="align: center"]20.73[/TD]
[TD="align: center"]16[/TD]
[TD="align: center"]67[/TD]
[TD="align: center"]44[/TD]
[TD="align: center"]0.07[/TD]
[TD="align: center"]13[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]40[/TD]
[TD="align: center"]27[/TD]
[TD="align: center"]0.04[/TD]

</tbody>

Excel tables to the web >> Excel Jeanie HTML 4


On the Evaluation Summary table for PW4090 engine and NOX, I need the value from the Engine Evaluation tab cell G14 to be placed at J17. If the table to the right (PW4077) were changed to PW4090, then the value at L14 (0.77) would need to be added to the (1.77) from cell G14 for a total of 2.54 (not shown). The pattern would be the same for the other pollutants. See blue shaded cells.

I hope I explained what I am looking for without any formulas present in the above tables.

 

[dwgnome]

Bump.

 

[dwgnome]

Aladin,

Hopefully my latest explanation version will allow you and or others to respond favorably.