Formula for spreadsheet total

T

The BeadKeeper

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.
 
P

Pete_UK

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top