Running Total

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ashley - 31 Mar 2007 18:06 GMT

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.

Reply to this Message

Bernard Liengme - 31 Mar 2007 18:30 GMT

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

Signature

Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

> Please help, I have a line made up of a product Name, Cost of
> Product,Total
[quoted text clipped - 4 lines]
> 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.

Reply to this Message