Creating a spreadsheet to track quotes.
I have multiple columns of information.
One has the item name, Next is the quantity required for that item, next column has the price of each part.
Each time that I add a price to an item, I want the spreadsheet to total the number of parts (items x quantity) required to quote.
So if there are 30 rows of items, the quantity of each can range from 1 to 5.
There is a total at the bottom for the quantity of items to quote. I want it to update each time a price is put into the price column and multiply the individual quantity that corresponds to that price and giving a total at the bottom.
"Required Spare Qty" "New Quoted Price for Each 1 $13,815 2 0 1 $17,338 2 0 1 $2,533 2 0 2 0 1 0