Help with a table/database

D

dsalmons

New Member
Joined
Sep 23, 2013
Messages
37
I have a matrix/table of ID's mileages and term durations any help appreciated.

What I want to do is get a figure based on all 3 parameters i.e.

The vehicle ID (fr_ID) = 40203
The Mileage (fr_mileage) = 30
The term (fr_24) = 24 months

[TABLE="width: 896"]
<colgroup><col width="64" span="14" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64, align: center"]fr_ID[/TD]
[TD="width: 64, align: center"]fr_year[/TD]
[TD="width: 64, align: center"]fr_month[/TD]
[TD="width: 64, align: center"]fr_mileage[/TD]
[TD="width: 64, align: center"]fr_6[/TD]
[TD="width: 64, align: center"]fr_12[/TD]
[TD="width: 64, align: center"]fr_18[/TD]
[TD="class: xl64, width: 64, align: center"]fr_24[/TD]
[TD="width: 64, align: center"]fr_30[/TD]
[TD="width: 64, align: center"]fr_36[/TD]
[TD="width: 64, align: center"]fr_42[/TD]
[TD="width: 64, align: center"]fr_48[/TD]
[TD="width: 64, align: center"]fr_54[/TD]
[TD="width: 64, align: center"]fr_60[/TD]
[/TR]
[TR]
[TD="align: center"]40203[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]16575[/TD]
[TD="align: center"]14975[/TD]
[TD="align: center"]13750[/TD]
[TD="align: center"]12300[/TD]
[TD="align: center"]11200[/TD]
[TD="align: center"]10100[/TD]
[TD="align: center"]9275[/TD]
[TD="align: center"]8350[/TD]
[TD="align: center"]7650[/TD]
[/TR]
[TR]
[TD="align: center"]40203[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]20[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]15725[/TD]
[TD="align: center"]14150[/TD]
[TD="align: center"]12975[/TD]
[TD="align: center"]11625[/TD]
[TD="align: center"]10600[/TD]
[TD="align: center"]9525[/TD]
[TD="align: center"]8700[/TD]
[TD="align: center"]7850[/TD]
[TD="align: center"]7200[/TD]
[/TR]
[TR]
[TD="class: xl64, align: center"]40203[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="class: xl64, align: center"]30[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]14850[/TD]
[TD="align: center"]13375[/TD]
[TD="class: xl65, align: center"]12225[/TD]
[TD="align: center"]11025[/TD]
[TD="align: center"]10100[/TD]
[TD="align: center"]9025[/TD]
[TD="align: center"]8175[/TD]
[TD="align: center"]7375[/TD]
[TD="align: center"]6750[/TD]
[/TR]
[TR]
[TD="align: center"]40203[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]40[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]14025[/TD]
[TD="align: center"]12625[/TD]
[TD="align: center"]11550[/TD]
[TD="align: center"]10400[/TD]
[TD="align: center"]9525[/TD]
[TD="align: center"]8525[/TD]
[TD="align: center"]7725[/TD]
[TD="align: center"]6925[/TD]
[TD="align: center"]6350[/TD]
[/TR]
[TR]
[TD="align: center"]40203[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]50[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]13275[/TD]
[TD="align: center"]11900[/TD]
[TD="align: center"]10850[/TD]
[TD="align: center"]9800[/TD]
[TD="align: center"]9000[/TD]
[TD="align: center"]8025[/TD]
[TD="align: center"]7275[/TD]
[TD="align: center"]6525[/TD]
[TD="align: center"]5950[/TD]
[/TR]
[TR]
[TD="align: center"]40203[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]60[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]12600[/TD]
[TD="align: center"]11275[/TD]
[TD="align: center"]10250[/TD]
[TD="align: center"]9250[/TD]
[TD="align: center"]8475[/TD]
[TD="align: center"]7575[/TD]
[TD="align: center"]6875[/TD]
[TD="align: center"]6150[/TD]
[TD="align: center"]5600[/TD]
[/TR]
[TR]
[TD="align: center"]40203[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]70[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]11975[/TD]
[TD="align: center"]10700[/TD]
[TD="align: center"]9675[/TD]
[TD="align: center"]8750[/TD]
[TD="align: center"]8025[/TD]
[TD="align: center"]7175[/TD]
[TD="align: center"]6500[/TD]
[TD="align: center"]5825[/TD]
[TD="align: center"]5275[/TD]
[/TR]
[TR]
[TD="align: center"]40203[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]80[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]11375[/TD]
[TD="align: center"]10125[/TD]
[TD="align: center"]9150[/TD]
[TD="align: center"]8250[/TD]
[TD="align: center"]7575[/TD]
[TD="align: center"]6775[/TD]
[TD="align: center"]6175[/TD]
[TD="align: center"]5500[/TD]
[TD="align: center"]4975[/TD]
[/TR]
[TR]
[TD="align: center"]40203[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]90[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]10800[/TD]
[TD="align: center"]9600[/TD]
[TD="align: center"]8650[/TD]
[TD="align: center"]7800[/TD]
[TD="align: center"]7150[/TD]
[TD="align: center"]6400[/TD]
[TD="align: center"]5825[/TD]
[TD="align: center"]5200[/TD]
[TD="align: center"]4700[/TD]
[/TR]
[TR]
[TD="align: center"]40203[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]100[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]10325[/TD]
[TD="align: center"]9150[/TD]
[TD="align: center"]8225[/TD]
[TD="align: center"]7425[/TD]
[TD="align: center"]6800[/TD]
[TD="align: center"]6100[/TD]
[TD="align: center"]5525[/TD]
[TD="align: center"]4925[/TD]
[TD="align: center"]4425[/TD]
[/TR]
[TR]
[TD="align: center"]40203[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]110[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]9850[/TD]
[TD="align: center"]8725[/TD]
[TD="align: center"]7800[/TD]
[TD="align: center"]7050[/TD]
[TD="align: center"]6450[/TD]
[TD="align: center"]5775[/TD]
[TD="align: center"]5250[/TD]
[TD="align: center"]4675[/TD]
[TD="align: center"]4175[/TD]
[/TR]
[TR]
[TD="align: center"]40203[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]120[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]9400[/TD]
[TD="align: center"]8300[/TD]
[TD="align: center"]7425[/TD]
[TD="align: center"]6700[/TD]
[TD="align: center"]6125[/TD]
[TD="align: center"]5500[/TD]
[TD="align: center"]5000[/TD]
[TD="align: center"]4425[/TD]
[TD="align: center"]3950[/TD]
[/TR]
[TR]
[TD="align: center"]40203[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]130[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]9025[/TD]
[TD="align: center"]7950[/TD]
[TD="align: center"]7075[/TD]
[TD="align: center"]6400[/TD]
[TD="align: center"]5850[/TD]
[TD="align: center"]5250[/TD]
[TD="align: center"]4775[/TD]
[TD="align: center"]4200[/TD]
[TD="align: center"]3750[/TD]
[/TR]
[TR]
[TD="align: center"]40203[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]140[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]8675[/TD]
[TD="align: center"]7625[/TD]
[TD="align: center"]6775[/TD]
[TD="align: center"]6100[/TD]
[TD="align: center"]5600[/TD]
[TD="align: center"]5025[/TD]
[TD="align: center"]4550[/TD]
[TD="align: center"]4000[/TD]
[TD="align: center"]3575[/TD]
[/TR]
[TR]
[TD="align: center"]40203[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]150[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]8325[/TD]
[TD="align: center"]7300[/TD]
[TD="align: center"]6450[/TD]
[TD="align: center"]5825[/TD]
[TD="align: center"]5350[/TD]
[TD="align: center"]4775[/TD]
[TD="align: center"]4350[/TD]
[TD="align: center"]3825[/TD]
[TD="align: center"]3400[/TD]
[/TR]
[TR]
[TD="align: center"]40203[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]160[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]8000[/TD]
[TD="align: center"]7000[/TD]
[TD="align: center"]6175[/TD]
[TD="align: center"]5575[/TD]
[TD="align: center"]5100[/TD]
[TD="align: center"]4575[/TD]
[TD="align: center"]4150[/TD]
[TD="align: center"]3650[/TD]
[TD="align: center"]3225[/TD]
[/TR]
[TR]
[TD="align: center"]40203[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]170[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]7675[/TD]
[TD="align: center"]6700[/TD]
[TD="align: center"]5900[/TD]
[TD="align: center"]5325[/TD]
[TD="align: center"]4875[/TD]
[TD="align: center"]4375[/TD]
[TD="align: center"]3975[/TD]
[TD="align: center"]3475[/TD]
[TD="align: center"]3050[/TD]
[/TR]
[TR]
[TD="align: center"]40203[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]180[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]7375[/TD]
[TD="align: center"]6425[/TD]
[TD="align: center"]5625[/TD]
[TD="align: center"]5075[/TD]
[TD="align: center"]4650[/TD]
[TD="align: center"]4175[/TD]
[TD="align: center"]3800[/TD]
[TD="align: center"]3300[/TD]
[TD="align: center"]2900[/TD]
[/TR]
[TR]
[TD="align: center"]40203[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]190[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]7075[/TD]
[TD="align: center"]6150[/TD]
[TD="align: center"]5375[/TD]
[TD="align: center"]4850[/TD]
[TD="align: center"]4450[/TD]
[TD="align: center"]3975[/TD]
[TD="align: center"]3625[/TD]
[TD="align: center"]3150[/TD]
[TD="align: center"]2750[/TD]
[/TR]
[TR]
[TD="align: center"]40203[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]200[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]6800[/TD]
[TD="align: center"]5875[/TD]
[TD="align: center"]5125[/TD]
[TD="align: center"]4625[/TD]
[TD="align: center"]4250[/TD]
[TD="align: center"]3800[/TD]
[TD="align: center"]3450[/TD]
[TD="align: center"]3000[/TD]
[TD="align: center"]2625[/TD]
[/TR]
[TR]
[TD="align: center"]40204[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]13950[/TD]
[TD="align: center"]12600[/TD]
[TD="align: center"]11800[/TD]
[TD="align: center"]10675[/TD]
[TD="align: center"]10000[/TD]
[TD="align: center"]9325[/TD]
[TD="align: center"]9075[/TD]
[TD="align: center"]8300[/TD]
[TD="align: center"]7875[/TD]
[/TR]
[TR]
[TD="align: center"]40204[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]20[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]13225[/TD]
[TD="align: center"]12000[/TD]
[TD="align: center"]11300[/TD]
[TD="align: center"]10225[/TD]
[TD="align: center"]9600[/TD]
[TD="align: center"]8925[/TD]
[TD="align: center"]8625[/TD]
[TD="align: center"]7850[/TD]
[TD="align: center"]7375[/TD]
[/TR]
[TR]
[TD="align: center"]40204[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]30[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]12625[/TD]
[TD="align: center"]11475[/TD]
[TD="align: center"]10800[/TD]
[TD="align: center"]9800[/TD]
[TD="align: center"]9200[/TD]
[TD="align: center"]8500[/TD]
[TD="align: center"]8175[/TD]
[TD="align: center"]7400[/TD]
[TD="align: center"]6925[/TD]
[/TR]
[TR]
[TD="align: center"]40204[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]40[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]12000[/TD]
[TD="align: center"]10900[/TD]
[TD="align: center"]10300[/TD]
[TD="align: center"]9300[/TD]
[TD="align: center"]8725[/TD]
[TD="align: center"]8075[/TD]
[TD="align: center"]7750[/TD]
[TD="align: center"]7000[/TD]
[TD="align: center"]6525[/TD]
[/TR]
[TR]
[TD="align: center"]40204[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]50[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]11400[/TD]
[TD="align: center"]10300[/TD]
[TD="align: center"]9625[/TD]
[TD="align: center"]8725[/TD]
[TD="align: center"]8175[/TD]
[TD="align: center"]7600[/TD]
[TD="align: center"]7325[/TD]
[TD="align: center"]6575[/TD]
[TD="align: center"]6125[/TD]
[/TR]
[TR]
[TD="align: center"]40204[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]60[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]10875[/TD]
[TD="align: center"]9750[/TD]
[TD="align: center"]9050[/TD]
[TD="align: center"]8200[/TD]
[TD="align: center"]7675[/TD]
[TD="align: center"]7150[/TD]
[TD="align: center"]6900[/TD]
[TD="align: center"]6200[/TD]
[TD="align: center"]5750[/TD]
[/TR]
[TR]
[TD="align: center"]40204[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]70[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]10400[/TD]
[TD="align: center"]9250[/TD]
[TD="align: center"]8500[/TD]
[TD="align: center"]7675[/TD]
[TD="align: center"]7175[/TD]
[TD="align: center"]6700[/TD]
[TD="align: center"]6475[/TD]
[TD="align: center"]5800[/TD]
[TD="align: center"]5375[/TD]
[/TR]
[TR]
[TD="align: center"]40204[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]80[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]9925[/TD]
[TD="align: center"]8775[/TD]
[TD="align: center"]8000[/TD]
[TD="align: center"]7225[/TD]
[TD="align: center"]6750[/TD]
[TD="align: center"]6275[/TD]
[TD="align: center"]6050[/TD]
[TD="align: center"]5425[/TD]
[TD="align: center"]5025[/TD]
[/TR]
[TR]
[TD="align: center"]40204[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]90[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]9475[/TD]
[TD="align: center"]8325[/TD]
[TD="align: center"]7500[/TD]
[TD="align: center"]6775[/TD]
[TD="align: center"]6350[/TD]
[TD="align: center"]5875[/TD]
[TD="align: center"]5625[/TD]
[TD="align: center"]5050[/TD]
[TD="align: center"]4675[/TD]
[/TR]
[TR]
[TD="align: center"]40204[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]100[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]9100[/TD]
[TD="align: center"]7925[/TD]
[TD="align: center"]7100[/TD]
[TD="align: center"]6400[/TD]
[TD="align: center"]5975[/TD]
[TD="align: center"]5500[/TD]
[TD="align: center"]5250[/TD]
[TD="align: center"]4700[/TD]
[TD="align: center"]4375[/TD]
[/TR]
[TR]
[TD="align: center"]40204[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]110[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]8725[/TD]
[TD="align: center"]7575[/TD]
[TD="align: center"]6700[/TD]
[TD="align: center"]6025[/TD]
[TD="align: center"]5600[/TD]
[TD="align: center"]5150[/TD]
[TD="align: center"]4900[/TD]
[TD="align: center"]4400[/TD]
[TD="align: center"]4100[/TD]
[/TR]
[TR]
[TD="align: center"]40204[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]120[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]8375[/TD]
[TD="align: center"]7225[/TD]
[TD="align: center"]6350[/TD]
[TD="align: center"]5675[/TD]
[TD="align: center"]5275[/TD]
[TD="align: center"]4825[/TD]
[TD="align: center"]4575[/TD]
[TD="align: center"]4125[/TD]
[TD="align: center"]3825[/TD]
[/TR]
[TR]
[TD="align: center"]40204[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]130[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]8050[/TD]
[TD="align: center"]6875[/TD]
[TD="align: center"]6000[/TD]
[TD="align: center"]5375[/TD]
[TD="align: center"]4975[/TD]
[TD="align: center"]4550[/TD]
[TD="align: center"]4300[/TD]
[TD="align: center"]3850[/TD]
[TD="align: center"]3575[/TD]
[/TR]
[TR]
[TD="align: center"]40204[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]140[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]7725[/TD]
[TD="align: center"]6550[/TD]
[TD="align: center"]5650[/TD]
[TD="align: center"]5075[/TD]
[TD="align: center"]4700[/TD]
[TD="align: center"]4300[/TD]
[TD="align: center"]4050[/TD]
[TD="align: center"]3625[/TD]
[TD="align: center"]3350[/TD]
[/TR]
[TR]
[TD="align: center"]40204[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]150[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]7425[/TD]
[TD="align: center"]6250[/TD]
[TD="align: center"]5350[/TD]
[TD="align: center"]4800[/TD]
[TD="align: center"]4450[/TD]
[TD="align: center"]4050[/TD]
[TD="align: center"]3800[/TD]
[TD="align: center"]3400[/TD]
[TD="align: center"]3150[/TD]
[/TR]
[TR]
[TD="align: center"]40204[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]160[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]7125[/TD]
[TD="align: center"]5975[/TD]
[TD="align: center"]5050[/TD]
[TD="align: center"]4525[/TD]
[TD="align: center"]4200[/TD]
[TD="align: center"]3800[/TD]
[TD="align: center"]3575[/TD]
[TD="align: center"]3200[/TD]
[TD="align: center"]2950[/TD]
[/TR]
[TR]
[TD="align: center"]40204[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]170[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]6825[/TD]
[TD="align: center"]5700[/TD]
[TD="align: center"]4775[/TD]
[TD="align: center"]4275[/TD]
[TD="align: center"]3975[/TD]
[TD="align: center"]3600[/TD]
[TD="align: center"]3350[/TD]
[TD="align: center"]3000[/TD]
[TD="align: center"]2775[/TD]
[/TR]
[TR]
[TD="align: center"]40204[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]180[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]6550[/TD]
[TD="align: center"]5425[/TD]
[TD="align: center"]4525[/TD]
[TD="align: center"]4050[/TD]
[TD="align: center"]3750[/TD]
[TD="align: center"]3375[/TD]
[TD="align: center"]3150[/TD]
[TD="align: center"]2825[/TD]
[TD="align: center"]2625[/TD]
[/TR]
[TR]
[TD="align: center"]40204[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]190[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]6300[/TD]
[TD="align: center"]5175[/TD]
[TD="align: center"]4275[/TD]
[TD="align: center"]3825[/TD]
[TD="align: center"]3550[/TD]
[TD="align: center"]3200[/TD]
[TD="align: center"]2975[/TD]
[TD="align: center"]2650[/TD]
[TD="align: center"]2450[/TD]
[/TR]
[TR]
[TD="align: center"]40204[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]200[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]6050[/TD]
[TD="align: center"]4950[/TD]
[TD="align: center"]4025[/TD]
[TD="align: center"]3625[/TD]
[TD="align: center"]3350[/TD]
[TD="align: center"]3000[/TD]
[TD="align: center"]2800[/TD]
[TD="align: center"]2500[/TD]
[TD="align: center"]2300[/TD]
[/TR]
[TR]
[TD="align: center"]40205[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]14700[/TD]
[TD="align: center"]13300[/TD]
[TD="align: center"]12450[/TD]
[TD="align: center"]11275[/TD]
[TD="align: center"]10550[/TD]
[TD="align: center"]9850[/TD]
[TD="align: center"]9550[/TD]
[TD="align: center"]8725[/TD]
[TD="align: center"]8275[/TD]
[/TR]
[TR]
[TD="align: center"]40205[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]20[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]13950[/TD]
[TD="align: center"]12675[/TD]
[TD="align: center"]11925[/TD]
[TD="align: center"]10800[/TD]
[TD="align: center"]10150[/TD]
[TD="align: center"]9425[/TD]
[TD="align: center"]9100[/TD]
[TD="align: center"]8250[/TD]
[TD="align: center"]7775[/TD]
[/TR]
</tbody>[/TABLE]






​
 
Sort by date Sort by votes
You can either do this with a complex formula, but I'd prefer sticking a helper column on your data that concatenates the fr_ID and fr_Mileage - you can then do a simple index/match or Vlookup.

Here's one formula that will do that you want - this can be much improved upon
Code: 
=SUM(IF(A2:A43=40203,1,0)*IF(D2:D43=30,1,0)*OFFSET(F2:F43,0,MATCH("fr_24",F1:N1,0)-1))

Needs entering with Ctrl+Shift and Enter
 
Last edited:
Upvote 0
You must log in or register to reply here.

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top