I want to sum a column of data starting from the cell above up to n cells above. n is given in a variable called custnum. This doesn't work:

ActiveCell.FormulaR1C1 = "=SUM(r[-custnum]C:R[-1]C)"

Hope someone can help!
Thanks
Sue