Thanks Bob.

Please se example at this file http://www.sto-nor.no/hjelp.xls

- håvard -

"Bob Phillips" wrote:

Not sure what you want, but your formula can be simplified

=SUMPRODUCT($B$7:$U$7*E8*$B11)

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Håvard Spaniland" wrote in
message ...
Please help !!

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)+((P riser!E8*$F$7)*$F11)+((Priser!E8*$G$7)*$G11)+((Pri ser!E8*$H$7)*$H11)+((Priser!E8*$I$7)*$I11)+((Prise r!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