Spreadsheet: 157995d1337949188-adding-values-using-if-formulas-trial-vertical
Sheet: Trial Vertical

 | DATE |  |  | 2012-05-10 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | VERTICAL NEW |  |  |  |  |  |  |  |  | PRIORITY - REQUIRED BY
 |  |  |  | 21349 |  |  |  |  |  |  |  |  |  |  | KM PLOT 70 [NAME]
 | Blind | Room |  | Blind |  | Exact |  | Blind |  |  |  |  | L/O |  | Bracket |  |  |  | Fabric |  |  |  |  | Fabric |  |  | Louvre |  | Blind | Control |  | Rail |  | Rail |  | Cord & Chain | W & C | Weight | Curved
 | No. | Name |  | [NAME] |  | Recess |  | [NAME] |  |  |  |  | Y/N |  | Type |  | Size |  | Name |  |  |  |  | Supplier |  |  | [NAME] |  | Bunch | Side |  | Type |  | Colour |  | Colour | Colour | Colour | Y/N
 | 1 | Lounge |  | 125.4 |  | R |  | 125 |  |  |  |  | N |  | T |  |  |  | OPUS BEIGE |  |  |  |  | DECORA |  |  | 89 |  | S | L |  | VOGUE |  | BLACK |  | BLACK | BLACK | BLACK | Y
 | 2 | Bed 1 |  | 157 |  | R |  | 150 |  |  |  |  | N |  | T |  |  |  | OPUS BEIGE |  |  |  |  | DECORA |  |  | 89 |  | S | L |  | VOGUE |  | BLACK |  | BLACK | BLACK | BLACK | N
 | 3 | Bed 2 |  | 159.2 |  | R |  | 158 |  |  |  |  | N |  | T |  |  |  | OPUS BEIGE |  |  |  |  | DECORA |  |  | 127 |  | S | L |  | VOGUE |  | BLACK |  | BLACK | BLACK | BLACK | Y
 | 4 | Kitchen |  | 15 |  | R |  | 198 |  |  |  |  | N |  | T |  |  |  | OPUS BEIGE |  |  |  |  | DECORA |  |  | 127 |  | S | R |  | VOGUE |  | BLACK |  | BLACK | BLACK | BLACK | N
 | 5 | Con 1 |  | 25.9 |  | E |  | 196.5 |  |  |  |  | N |  | SF |  | 3.5 |  | STIPPLE WHITE |  |  |  |  | LOUVOLITE |  |  | 89 |  | R | L |  | STD |  | WHITE |  | WHITE | WHITE | WHITE | N
 | 6 | Con 2 |  | 49.5 |  | E |  | 125.4 |  |  |  |  | N |  | SF |  | 3.5 |  | STIPPLE WHITE |  |  |  |  | LOUVOLITE |  |  | 89 |  | R | R |  | STD |  | WHITE |  | WHITE | WHITE | WHITE | N
 | 7 | Con 3 |  | 258 |  | E |  | 128.1 |  |  |  |  | N |  | SF |  | 3.5 |  | STIPPLE WHITE |  |  |  |  | LOUVOLITE |  |  | 89 |  | L | L |  | STD |  | WHITE |  | WHITE | WHITE | WHITE | Y
 | 8 | Con 4 |  | 159 |  | R |  | 125.2 |  |  |  |  | N |  | FF |  | 5 |  | STIPPLE WHITE |  |  |  |  | LOUVOLITE |  |  | 89 |  | L | R |  | STD |  | WHITE |  | WHITE | WHITE | WHITE | N
 | 9 | Con 5 |  | 158 |  | R |  | 152.9 |  |  |  |  | N |  | FF |  | 1 |  | STIPPLE WHITE |  |  |  |  | LOUVOLITE |  |  | 89 |  | R | L |  | STD |  | WHITE |  | WHITE | WHITE | WHITE | Y
 | 10 | Con 6 |  | 97 |  | R |  | 97 |  |  |  |  | Y |  | FF |  | 5 |  | STIPPLE WHITE |  |  |  |  | LOUVOLITE |  |  | 89 |  | L | R |  | STD |  | WHITE |  | WHITE | WHITE | WHITE | N
 | TRACKS
 | Blind |  | Rail | Rail |  | Track |  | Rod | Total | Rounded | Split |  | Blind |  | Control |  | Louvre |  |  | L/H |  | R/H |  |  | [NAME] | [NAME] |  |  | Chain |  | Chain |  | Bracket |  | Bracket | Bracket |  |  | Made
 | No. |  | Type | Colour |  | Length |  | Length | Carriers | Carriers | Carriers |  | Bunch |  | Side |  | Size |  |  | Carriers |  | Carriers |  |  | Colour | Length |  |  | Colour |  | Length |  | Type |  | Size | Qty |  |  | By
 | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
 | Blind | Room |  | Blind |  | Exact |  | Blind |  |  |  |  | L/O |  | Bracket |  |  |  | Fabric |  |  |  |  | Fabric |  |  | Louvre |  | Blind |  |  | Rail |  | Rail |  | [NAME] | Chain | Weight | Curved
 | No. | Name |  | [NAME] |  | Recess |  | [NAME] |  |  |  |  | Y/N |  | Type |  | Size |  | Name |  |  |  |  | Supplier |  |  | [NAME] |  | Bunch |  |  | Type |  | Colour |  | Colour | Colour | Colour | Y/N
 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BLACK
 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BLACK
 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BLACK
 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BLACK
 | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WHITE
 | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WHITE
 | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WHITE
 | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WHITE
 | 9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WHITE
 | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WHITE
 | LOUVRES
 | Blind |  | Fabric |  |  |  |  | Fabric |  |  |  |  |  |  | Louvre |  | No Of | Extra |  | Split or |  | Cut |  | Weight & Chain |  | W & C |  |  | ELL |  | Fabric |  | Fabric |  |  |  | Cut | Sewn | W & C
 | No. |  | Name |  |  |  |  | Supplier |  |  |  |  |  |  | [NAME] |  | Louvres | Louvres |  | One Way |  | Size |  | Bunch |  | Colour |  |  | Size |  | Quantity |  | 0.1 |  |  |  | By | By | By
 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | mtrs |  | mtrs
 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | mtrs |  | mtrs
 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | mtrs |  | mtrs
 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | mtrs |  | mtrs
 | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | mtrs |  | mtrs
 | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | mtrs |  | mtrs
 | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | mtrs |  | mtrs
 | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | mtrs |  | mtrs
 | 9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | mtrs |  | mtrs
 | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | mtrs |  | mtrs