Proration formula

Hi Gurus,

I am trying to create the following formula but don't seem to be able to figure out how to.

I have a column with quantity and a cell with a freight value I need to take the freight value and divided by the total in the quantity and at the sometime populate the row that contain a quantity value.

Thanks
Rudy