H

#### HÃ¥vard Spaniland

I need a simple way to repeat some parts of a forula within a cell.

We are selling products which are priced pr millimeter, and we calculate

totale value of goods in stock. The formula collect mm price from one

sheet--> mulitiply with actual width-->multiply with quantity of each width.

Example of structue

10 20 30 40 45 48 Total value

2 546 321 21 654 546 325.213

The actual formula I currently use:

=((Priser!E8*$B$7)*$B11)+((Priser!E8*$C$7)*$C11)+((Priser!E8*$D$7)*$D11)+((Priser!E8*$E$7)*$E11)+((Priser!E8*$F$7)*$F11)+((Priser!E8*$G$7)*$G11)+((Priser!E8*$H$7)*$H11)+((Priser!E8*$I$7)*$I11)+((Priser!E8*$J$7)*$J11)+((Priser!E8*$K$7)*$K11)+((Priser!E8*$L$7)*$L11)+((Priser!E8*$M$7)*$M11)+((Priser!E8*$N$7)*$N11)+((Priser!E8*$O$7)*$O11)+((Priser!E8*$P$7)*$P11)+((Priser!E8*$Q$7)*$Q11)+((Priser!E8*$R$7)*$R11)+((Priser!E8*$S$7)*$S11)+((Priser!E8*$T$7)*$T11)+((Priser!E8*$U$7)*$U11)

The basic formula is ((Priser!E8*$U$7)*$U11) but copied to get all cells.

Please help me find a solution for this formula, and simplify my world....

Best regards