Prev: Excel 2007 (Not Responding)
Next: Is there shortcut for merging cells when selected in Excel?
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
 | 
Pages: 1
Prev: Excel 2007 (Not Responding)
Next: Is there shortcut for merging cells when selected in Excel?