I have a spread that lists all of my inventory item numbers, items, etc.

To simplify:

Column
B=Qty D=$ F=Qty H=$ J=Qty L=$


I need a formula that as I enter my quantities, it will automatically
calculate a total at the bottom of the spread without changing my $ column.

Thanks.