what formula can i use?

[MargieGeorge]

HI

I am wanting to drag down the column to auto complete the formula but I cant get it to work

first column % divided by total amount at bottom

Colum I Column L Formula

7.83% $176 =I5*$L18 $176.63

3.1% $70.65 =???? $70.65

$2256.20 (column L18) Total

At present I have to do each formula in each cell to get correct amount
thanks in advance

cheers

Margie