From: LYNABY on 20 May 2010 12:52 DESCRIPTION PART # PART \$ LABOUR BDY R/I L PICKUP BED SIDE PANEL 25871809 \$642.50 13.5 \$921.65 REF REFINISH L BED OUTER SIDE PANEL 3.0 \$204.81 REF REFINISH L ADD FOR EDGE 0.5 \$34.14 BDY R/I FUEL TANK EXISTING 1.0 \$68.27 PAINT MATERIALS SHOP MATERIALS I NEED TO ADD ALL THE LABOUR TIME FOR ROWS STARTING WITH BDY TOGETHER AND MUTIPLY THEM BY 6.12 TO GET MY SHOP MATERIALS TOTAL, AND ADD ALL LABOUR TIME FOR ROWS STARTING WITH REF TOGETHER AND MULTIPLY THEM BY 32.68 TO GET MY PAINT MATERIALS TOTAL. WHAT KIND OF A FORMULA DO I USE AND HOW DO I SET IT UP? -- LYNABY From: Arlen on 20 May 2010 14:24 Lynaby, Your spreadsheet is a little jumbled, so I'm going to assume that you have 13.5 hours for BDY job 1 and 1.0 hours for BDY job 2. Also, let us both assume that 13.5 is in cell E1 and 1.0 is in cell E2. To create the formula you need, click an empty cell and type =(E1+E2)*6.12 to calculate total Shop Materials labour cost. For the total Paint Materials labour cost, use the same structure as above, but E1 and E2 will change to whatever cells have 3.0 and 0.5 and 6.12 will change to 32.68. Good louck! "LYNABY" wrote: > DESCRIPTION PART # PART \$ LABOUR > BDY R/I L PICKUP BED SIDE PANEL 25871809 \$642.50 13.5 \$921.65 > REF REFINISH L BED OUTER SIDE PANEL 3.0 \$204.81 > REF REFINISH L ADD FOR EDGE 0.5 \$34.14 > BDY R/I FUEL TANK EXISTING 1.0 \$68.27 > > > > PAINT MATERIALS > SHOP MATERIALS > > > I NEED TO ADD ALL THE LABOUR TIME FOR ROWS STARTING WITH BDY TOGETHER AND > MUTIPLY THEM BY 6.12 TO GET MY SHOP MATERIALS TOTAL, AND ADD ALL LABOUR TIME > FOR ROWS STARTING WITH REF TOGETHER AND MULTIPLY THEM BY 32.68 TO GET MY > PAINT MATERIALS TOTAL. WHAT KIND OF A FORMULA DO I USE AND HOW DO I SET IT > UP? > > > -- > LYNABY  |