Running totals

[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!

 

[Frank Kabel]

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