Running totals

  • Thread starter Thread starter alisha
  • Start date Start date
A

alisha

I would like to know how to keep a running total of items
purchased by my customers. For example

Pro Climber|Units|Price|Carabiners|Unit|Price|...TOTAL

so lets say cus. buys 2 units of the pro climber @ $20.00
and 4 units of the carabiners @ $15.00...how would i keep
a running total of the items he's purchased. please
advise. Thanks!
 
Hi
I would suggest a different spreadsheet layour.
Product type - Units - Price - Costs - Running total

Now in cell D2 enter the formula
=IF(A2<>"",B2*C2,"")
and copy this down

in cell E2 enter
=IF(C2<>"",C2,"")

and in E3 enter
=IF(C3<>"",D2+C3,"")
and copy this down
 
Back
Top