Running Total

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dynamic Table Problem 5
multiple calculations in 1 cell 1
Cost increase rate 3
How do I set up sub-headings in Excel? 1
Max Price and Min Price paid for an item - Rephrsed 4
How to create a bubble chart with more than 2 variables 0
ON SUBTOTAL LINE CARRY FORWARD DENOMINATOR FROM PREVIOUS LINE 1
Payback in Years 4

Back
Top