Look up & add multiple entries along non-contiguous columns!

[witham]

Hey y'all,

I need to look up a set item across a number of non-contiguous columns, then add together the total of all entries listed. Any suggestions?

There is an example below:

Assumptions: First cell A1, answer in cloumn AD.
So in the column AC I will add up all the instances of "gear box" (of which there are 3) and in column AD I will give a total of all those gear boxes. While the entries (e.g. "gear box") are from a drop down list, their prices are manually entered & each one can be different!

Thanks in advance!


<TABLE style="WIDTH: 1509pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=2011 x:str><COLGROUP><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 86pt; mso-width-source: userset; mso-width-alt: 4169" width=114><COL style="WIDTH: 89pt; mso-width-source: userset; mso-width-alt: 4352" width=119><COL style="WIDTH: 86pt; mso-width-source: userset; mso-width-alt: 4169" width=114><COL style="WIDTH: 48pt" span=25 width=64><TBODY><TR style="HEIGHT: 18pt" height=24><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #333333; WIDTH: 48pt; HEIGHT: 18pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl27 height=24 width=64>Period 1</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #333333; WIDTH: 86pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl43 width=114 x:num="40868.538973148148">21-Nov</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #333333; WIDTH: 89pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid" class=xl36 width=119 x:num>47</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #333333; WIDTH: 86pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl26 width=114></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #333333; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl42 width=64 align=right x:num>27</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #333333; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl42 width=64 align=right x:num>27</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #333333; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl42 width=64 align=right x:num>27</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #333333; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl42 width=64 align=right x:num>27</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #333333; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl42 width=64 align=right x:num>27</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #333333; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl42 width=64 align=right x:num>27</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #333333; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl42 width=64 align=right x:num>27</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #333333; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl42 width=64 align=right x:num>27</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #333333; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl42 width=64 align=right x:num>27</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #333333; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl42 width=64 align=right x:num>27</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #333333; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl42 width=64 align=right x:num>27</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #333333; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl42 width=64 align=right x:num>28</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #333333; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl42 width=64 align=right x:num>28</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #333333; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl42 width=64 align=right x:num>28</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #333333; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl42 width=64 align=right x:num>28</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #333333; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl42 width=64 align=right x:num>28</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #333333; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl42 width=64 align=right x:num>28</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #333333; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl42 width=64 align=right x:num>28</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #333333; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl42 width=64 align=right x:num>28</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #333333; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl42 width=64 align=right x:num>28</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #333333; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl42 width=64 align=right x:num>28</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #333333; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl42 width=64 align=right x:num>28</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: black; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl44 width=64></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl49 width=64></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #333333; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl25 width=64></TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: white; HEIGHT: 15.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: colspan" class=xl37 height=21 colSpan=2>Fleet Totals</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid" class=xl38 x:num="9819">£9,819.00</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl39 x:num="9819">£9,819.00</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl40> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl40> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl40> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl40> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl40> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl40> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl40> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl40> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl40> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl40> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl40> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl40> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl40> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl40> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl40> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl40> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl40> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl40> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl40> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl40> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl40> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl40> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: black; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl45> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl48> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl41> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl30 height=17>Fleet Number</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl30>Registration</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid" class=xl34>Total Repairs</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl30>High (Total)</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl32>High</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl32>H1</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl32>Note</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl32>H2</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl32>Note</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl32>H3</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl32>Note</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl32>H4</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl32>Note</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl32>H5</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl32>Note</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl32>High</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl32>H1</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl32>Note</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl32>H2</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl32>Note</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl32>H3</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl32>Note</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl32>H4</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl32>Note</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl32>H5</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl32>Note</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: black; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl46></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl50>Note SUMS</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl30></TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND: silver; HEIGHT: 15.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl28 height=21 x:num>51</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl29>AA00AAA</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid; mso-ignore: style; mso-pattern: auto none" class=xl35 x:num="2187"> 2,187.00 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl31 x:num="2187"> 2,187.00 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl33 x:num>1580</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl33 x:num>1580</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl33>Gear Box</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl33> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl33> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl33> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl33> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl33> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl33> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl33> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl33> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl33 x:num>607</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl33 x:num>607</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl33>Dashboard</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl33> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl33> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl33> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl33> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl33> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl33> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl33> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl33> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl47> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl51>Gear Box</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl24 x:num>3</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 15.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl28 height=21 x:num>52</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl29>AA00AAB</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid" class=xl35 x:num="3060"> 3,060.00 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl31 x:num="3060"> 3,060.00 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl33 x:num>0</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl33> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl33> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl33> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl33> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl33> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl33> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl33> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl33> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl33> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl33> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl33 x:num>3060</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl33 x:num>885</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl33>Air Heater</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl33 x:num>2175</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl33>Gear Box</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl33> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl33> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl33> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl33> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl33> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl33> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: black; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl47> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl51>Axle</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl24 x:num>1</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND: silver; HEIGHT: 15.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl28 height=21 x:num>53</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl29>AA00AAC</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid; mso-ignore: style; mso-pattern: auto none" class=xl35 x:num="1898"> 1,898.00 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl31 x:num="1898"> 1,898.00 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl33 x:num>1898</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl33 x:num>623</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl33>Dashboard</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl33 x:num>1275</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl33>Gear Box</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl33> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl33> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl33> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl33> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl33> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl33> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl33 x:num>0</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl33> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl33> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl33> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl33> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl33> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl33> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl33> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl33> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl33> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl33> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl47> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl51>Dashboard</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl24 x:num>3</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 15.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl28 height=21 x:num>54</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl29>AA00AAD</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid" class=xl35 x:num="2674"> 2,674.00 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl31 x:num="2674"> 2,674.00 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl33 x:num>2674</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl33 x:num>645</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl33>Dashboard</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl33 x:num>1271</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl33>Axle</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl33 x:num>758</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl33>Air Heater</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl33> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl33> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl33> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl33> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl33 x:num>0</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl33> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl33> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl33> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl33> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl33> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl33> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl33> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl33> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl33> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl33> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: black; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl47> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl51>Air Heater</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl24 x:num>2</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND: silver; HEIGHT: 15.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl28 height=21 x:num>55</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl29>AA00AAE</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 0.5pt solid; mso-ignore: style; mso-pattern: auto none" class=xl35 x:num="0"> - </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl31 x:num="0"> - </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl33 x:num>0</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl33> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl33> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl33> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl33> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl33> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl33> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl33> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl33> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl33> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl33> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl33 x:num>0</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl33> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl33> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl33> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl33> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl33> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl33> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl33> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl33> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl33> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl33> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl47> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl51>Engine</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND: silver; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: style; mso-pattern: auto none" class=xl24 x:num>0</TD></TR></TBODY></TABLE>

 

[Trevor G]

You can use a countif formula

Excel Workbook
	AB	AC
3	Note SUMS
4	Gear Box	3
5	Axle	1
6	Dashboard	3
7	Air Heater	2
8	Engine	0
Sheet1

 

[witham]

Thanks for the reply Trevor.

Re-reading that I was not clear!

Its a COUNTIF that poplulates the column at the end. So I get a total of all the 'gear boxes'.
But I need to add up the cost of the gear boxes, which in the above example would be the prices in the H1,H2,H3 columns.

Any other suggestions? Thanks

 

[sheetspread]

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE
1
2	Period 1	####	47		27	27	27	27	27	27	27	27	27	27	27	28	28	28	28	28	28	28	28	28	28	28
3	Fleet Totals		9,819.00	9,819.00
4	Fleet Number	Registration	Total Repairs	High (Total)	High	H1	Note	H2	Note	H3	Note	H4	Note	H5	Note	High	H1	Note	H2	Note	H3	Note	H4	Note	H5	Note		Note SUMS
5	51	AA00AAA	2,187.00	2,187.00	1580	1580	Gear Box									607	607	Dashboard										Gear Box	3	3	5030
6	52	AA00AAB	3,060.00	3,060.00	0											3060	885	Air Heater	2175	Gear Box								Axle	1	1	1271
7	53	AA00AAC	1,898.00	1,898.00	1898	623	Dashboard	1275	Gear Box							0												Dashboard	3	3	1875
8	54	AA00AAD	2,674.00	2,674.00	2674	645	Dashboard	1271	Axle	758	Air Heater					0												Air Heater	2	2	1643
9	55	AA00AAE	-	-	0											0												Engine	0	0	0
Sheet2

 

[witham]

Hey Sheetspread,

Thank you so much! You have brought a big happy smile to my confusing Monday!

Have a great week!