I have a template sheet with data that has to be summed
up. The current range is C2:c314. However, the next time I
get the data the data range might be c2: c228.

The data will be contiguous (there won't be any gaps). Row
C1 is a header. I tried to record a macro by finding the
last active cell in Col C, going one cell down, typing =sum
(, hitting the up arrow key, CTRL + Shift + up arrow key,
and then hitting the down arrow key to get my data range.
This is what the code reads:

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

Can any one help by correcting this so that from the
activecell in Col C it will add all the numbers except for
the topmost cell, C1?

I hope the question is clear.

Thanks for your help.

--Perry