you can just do it: =SUM($A$1:A$1) and pull down
$A$1 - is the starting row which will always remain fixed