I have written a simple spreadsheet that calculates the quantity of items (Col A)at a given price (Col E) and puts the product of those two columns in Column F. Using the sum formula in Col G =SUM(G3,F4) etc, Col G then shows the running balance as I add additional rows.
Let's say I have 6...