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.

It would be easier to have it at the top of your sheet - that way you
can see it at all times by freezing the top two rows. Insert a new row
1, move cursor to A3 then Window | Freeze Panes. Then in B1 put this
formula:

=SUM(B3:B100)

adjust the 100 to suit how many items you expect to have, then copy
into D1, F1, H1, J1 and L1. You might want to format the $ columns as
currency.

Hope this helps.

Pete

On Oct 1, 2:46 pm, The BeadKeeper <The
wrote:
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.