well if you have a variable  that tells you how many rows... use that
variable something like this

range("c" & var + 1).formula = sum("c1":"c" & var)
just air code.. but i think something like this should do it