Multiplying numbers of seperate columns that are both seperated by carriage returns?

[ari35]

I have a spreadsheet that is used for construction change orders. The way it has to be set up there is 4 columns description, qty,cost per, and total. The description qty and cost per are all being pulled from another sheet in the work book and to create seperate line items I just use the carriage return feature on the other sheet. I need to get my total column to take and multiply qty x cost and enter it into total, then take the next carriage returned value and go quanity x cost and then move onto next carriage returned item. at the bottom of the totals column i will need a formula that will add up all the totals as well.


Thanks in advance for any help!

[Richard Buttrey]

Hi,

Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.

Show a before and after situation and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.

Regards

[ari35]

thanks for the suggestion here is a link with sheet!

http://dl.dropbox.com/u/22932122/change%20order.xlsx