Please help, I have a line made up of a product Name, Cost of Product,Total
Units,and finaly total cost.

The total cost is a SUM of COST*UNITS.

I would like to have the resolt sent to a new square and kept as a running
total when a new calcalation is made in the origenal line.

=SUMPRODUCT(A1:A20,B1:B20)
puts the sum of a1*b1 + a2*b2 +....
in a cell (please, NOT a 'square')
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Ashley" wrote in message
...
Please help, I have a line made up of a product Name, Cost of
Product,Total
Units,and finaly total cost.

The total cost is a SUM of COST*UNITS.

I would like to have the resolt sent to a new square and kept as a running
total when a new calcalation is made in the origenal line.