I am trying to come up with an easy to repeat formula (e.g. when adding a new row the formula is repeated) for calculating the totals in the row highlighted yellow (see attachment).

I am currently using the formula (below) in row '29'. The formula is specific to column 'B' for total in 'B29' (highlighted green in the attachment).

Currently I am having to retype the formula for each new row I add and I am pretty sure the formula is in a 'bad' format.

"=L15(B3*$I$3)+(B4*$I$4)+(B5*$I$5)+(B6*$I$6)+(B7*$ I$7)+(B8*$I$8)+(B9*$I$9)+(B10*$I$10)+(B11*$I$11)+( B12*$I$12)+(B13*$I$13)+(B14*$I$14)+(B15*$I$15)+(B1 6*$I$16)+(B17*$I$17)+(B18*$I$18)+(B19*$I$19)+(B20* $I$20)+(B21*$I$21)+(B22*$I$22)+(B23*$I$23)+(B24*$I $24)+(B25*$I$25)"

Any help much appreciated.

Thanks
James