Running Total

A

Ashley

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.
 
B

Bernard Liengme

=SUMPRODUCT(A1:A20,B1:B20)
puts the sum of a1*b1 + a2*b2 +....
in a cell (please, NOT a 'square')
best wishes
 
Top