Trouble with Formula (in loop)

Hi

I am attempting to use a formula within a loop and I am not sure how to write it...or reference it...

I have... Cells(i, h).FormulaR1C1 = "=SUM(RC[-(AddCols(g))]:RC[-1])"

(BTW: g = 0 to 41 and Dim AddCols(41) As Integer - maybe this is incorrect????) It appears to not like the (AddCols(g)) but maybe it does not like the cells part...?

I am trying to sum up various columns dependant on the variable 'AddCols'.

Can anyone help..?

dugong