I have a spreadsheet that I use for an order guide. The spreadsheet contains
the 1st sheet which is for inventory and the next 6 sheets are the order
pages.
Each time I enter a # of pcs. on the order sheet it reduces the inventory
sheet #'s.
Heres the delima. I have set up a new column to pull over from the inventory
page and displays the price on each order sheet. I would like to set up a
formula that references the price , multiplies it by the # of pcs,and at a
new cell adds all the references from the entire column giving me a dollar
total. Any thoughts?